VBA Trying to add page break...not working

[lancekeith]

I've written the following code to add a second page to the file when additional rows are needed. After the add, I'm trying to set the page break so that it breaks in the proper location. I've tried several different pieces of code, none seem to work.

The following isn't giving me any error msg, yet the stubborn page break remains before row 65, rather than before row 62 where I want it.

Any help on why this isn't working would be appreciated.

Please Login or Register  to view this content.

[shg]

When you set Print to Pages Wide/Tall, manual page breaks are ignored. You can instead set the print scaling, then insert your page breaks.

[lancekeith]

Understood, thanks

[shg]

You're welcome.