Adding Page Breaks

[winshent]

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?

 

[Andrew Poulsom]

Welcome to the MrExcel Board.

If you insert a manual page break, automatic page breaks below it move down. Isn't that happening for you?