Trying to use a Macro to insert a page break every 50 rows starting with row 2.

I've tried this several times and I just cannot get it to work. I was able to use the below macro in a previous version of this document and it worked fine but in this one, it either doesn't work at all or I get a message saying that I can only enter 1024 page breaks. It is an insanely long spreadsheet but it worked before so I'm just wondering what I'm doing wrong here. Any help is appreciated!

Here is what I used previously. The previous document did have the same amount of rows (223620).

Please Login or Register  to view this content.

See http://support.microsoft.com/kb/284916

There is a limit of 1,026 page breaks per worksheet. You are trying to apply 4,384.

As you want your page breaks to be equally spaced, why not just adjust your page scaling to fit by 4,384 pages high?

Hello Kashikoi09,

Welcome to the Forum!

I am not sure why it worked the first time. Excel, depending on the version, only allows 1026 manual horizontal page breaks (See article here)