Hello,
I'm working on a simple spreadsheet which has to be printed on one page. I wrote a macro in VBA to do this dynamically (removing all empty lines from the print), but I'm having the following issues:
1) When running the 'MyPrint' macro, I get the printpreview as expected, however, sometimes I get a grey screen instead (see pictures). This can eiter be partially or covering the full screen. Sometimes when I zoom in and out, the grey screen disappears. Does anyone know if there's something wrong in my code?
2) The program is quite slow, can this be prevented? I'm not sure what the bottleneck is.
Any help is much appreciated. Thank you in advance.
Best regards,
Thomas
P.s. please find attached pictures and the excel worksheet.
P.p.s. I copied the macro below, for convenience:
Bookmarks