Insert Page Breaks Every Nth row, except for the first page.

[chaddug]

Hi, I need a macro to insert a page break after the 44th row, and then every 34 rows from there on out. I found a macro that I thought would do this, but its not working for some reason and I cant seem to figure out why. Every page needs to have a width from Column A to Column M.

Thanks in advance for any help you can provide.

Please Login or Register  to view this content.

[ragulduy]

Maybe try:

Please Login or Register  to view this content.

[chaddug]

Thanks for the reply!

When I try that I get:
Compile Error
Sub or function not defined

Then it highlights 'BeforeRange' and Sub testme() turns yellow.

[ragulduy]

Sorry, change beforerange to before:=range

[chaddug]

That fixed the error, but now it just seems to set the page breaks to what they would be if you clicked reset all page breaks (between columns J and K and Rows 41 and 42).

[ragulduy]

I just double checked and for me it creates them between 44 and 45 and then every 34 rows. Can you post a workbook with the code you are using in it where it is not working?

[chaddug]

It seems to be kind of working. It is setting a horizontal page break where its supposed to, but its not removing the old page breaks.

Example.xlsm