I’ve written an Access app that exports data to Excel and then formats it into a personal financial statement. The first time I run it, it works great. The second time, I get the error: “Method ‘Cells’ of object ‘_Global’ Failed” at a line which reads as follows:
appExcel.ActiveSheet.Range(Cells(RowNo, 1), Cells(RowNo, 8)).Select
Any ideas? It seems to generate this error only after I’ve run the report previously. If I close out of Access and get back in, it works fine the first time but bugs out again the second.