Adding Page Breaks

winshent

Registered User.
Local time
Today, 10:38
Joined
Mar 3, 2008
Messages
162
I have macro that deletes and existing report sheet and recreates it from scratch.

the macro outputs tables and graphs for each client in the spreadsheet..

in vba, i manually add a pagebreak after every 4 client outputs. However, excel still keeps the default pagebreak that exists two rows below.. Hence, when printing, i have a blank page in between every 4 clients..

how can i get around this?
 

Users who are viewing this thread

Back
Top Bottom