- Joined
- Feb 8, 2002
- Messages
- 3,391
- Office Version
- 365
- Platform
- Windows
I've got a complex VBA application. The thing runs really fast. Until I print the worksheet.
After printing the worksheet, the pagebreaks lines appear and the code runs at least 10 times slower than without the pagebreak lines.
The *right* thing to do is to figure out why this is happening, but the *quick* thing I am trying to do (spring break starts in 3 days) is to find a way to basically set the PageSetup to nothing. Friends who have an international version of Excel suggested
Set ActiveSheet.PageSetup = Nothing
but this causes an object 438 error for me in Excel 2000 or Excel 2002.
Any idea on how to "undo" the page setup settings so that this application can go back to it's speedy performance after printing?
Bill
After printing the worksheet, the pagebreaks lines appear and the code runs at least 10 times slower than without the pagebreak lines.
The *right* thing to do is to figure out why this is happening, but the *quick* thing I am trying to do (spring break starts in 3 days) is to find a way to basically set the PageSetup to nothing. Friends who have an international version of Excel suggested
Set ActiveSheet.PageSetup = Nothing
but this causes an object 438 error for me in Excel 2000 or Excel 2002.
Any idea on how to "undo" the page setup settings so that this application can go back to it's speedy performance after printing?
Bill