Hi all,
I have some VBA which produces an excel sheet with data. When using Print Preview after the code has run, it shows 2,500 blank pages even though there is only one page of data. Now I understand why this happens and to overcome this I SAVE the sheet then when I preview again, the blank pages dissapear.
However, rather than saving the sheet before print previewing (as the user may not want to do this), is there some code which will eliminate this erroneous blank data.
Cheers,
Paul.
I have some VBA which produces an excel sheet with data. When using Print Preview after the code has run, it shows 2,500 blank pages even though there is only one page of data. Now I understand why this happens and to overcome this I SAVE the sheet then when I preview again, the blank pages dissapear.
However, rather than saving the sheet before print previewing (as the user may not want to do this), is there some code which will eliminate this erroneous blank data.
Cheers,
Paul.