Access 2003 Error: Method "Cells" of object '_Global' Failed - TechRepublic
Question
May 22, 2008 at 10:26 AM
curtishearn

Access 2003 Error: Method “Cells” of object ‘_Global’ Failed

by curtishearn . Updated 18 years, 2 months ago

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.

This discussion is locked

All Comments