CPGDeveloper
Board Regular
- Joined
- Oct 8, 2008
- Messages
- 190
Hi All --
Apologies if that has been covered somewhere -- but I cannot seem to find it while searching.
I have an Access Based Reporting Application, where a user can select a specific report in a drop down, and then it runs that report and exports it to excel. Two of the reports in particular will not allow the user to run them twice in a row. It works fine the first time, but the 2nd time I get VBA Error 462.
It's happening specifically on this line of code:
lr = oSheet.Cells(Rows.Count, 1).End(xlUp).Row
'oSheet' being an Excel Worksheet. This is to determine the last row of the report in order to do some formatting. Perhaps there's another way to write this that would avoid the error?
Apologies if that has been covered somewhere -- but I cannot seem to find it while searching.
I have an Access Based Reporting Application, where a user can select a specific report in a drop down, and then it runs that report and exports it to excel. Two of the reports in particular will not allow the user to run them twice in a row. It works fine the first time, but the 2nd time I get VBA Error 462.
It's happening specifically on this line of code:
lr = oSheet.Cells(Rows.Count, 1).End(xlUp).Row
'oSheet' being an Excel Worksheet. This is to determine the last row of the report in order to do some formatting. Perhaps there's another way to write this that would avoid the error?
