Set Page Breaks automotically based in criteria

I have a macro to preview the range before printing and to set page breaks


When in Page preview, I have to manually set the page break lines and the macro is not setting them correctly

I would like the page breaks to appear as follows:


1) Where Other appears in Col H, page break to be below this
2) Where Amount PAYABLE/(Refund) is in Col E page break to be below this


It would be appreciated if someone could assist me

Please Login or Register  to view this content.

Hi Howard,
you can do something like this, but the problem is that the automatic pagebreaks (which cannot be removed) are set before the manual pagebreak, simply because the printable range is bigger than you want to print within the manual breaks. It's better to delete some of the blank lines.

Please Login or Register  to view this content.

Cheers
Erwin