I was redoing some VBA code on a workbook that formats a page and copies data and paste data into it. I keep getting a printer error. The sheet in question wouldn't even let me do a print preview manually. I got it working by inserting a new sheet then copying the problem sheet and pasting it into the new sheet. I changed the name of the old sheet then renamed the new one to what the old one was. Now I can manually do a print preview of the sheet and my code executes as normal. Anybody have insight on why this would work after copying the entire sheet into a new one but not work on the old sheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can't print or print preview?? Weird
- Thread starter Progrower
- Start date
