Macro that does page break after Nth row

[gabster786]

What I have thus far: We get a bunch of data that ranges anywhere from 100 lines to 30000 lines and it has to be included in the report. I created a macro that will cut my data at the 110th row and separate it into four columns so that basically 440 lines of data can be read on one page. On the ones that have 30000 lines of data, manually page breaking it can be a pain.

I need a macro that will do a page break on the first page at 115, and then 110 rows after that. I also need it to extend to column S or rather have the print area set to where there's data in it.

Please help!!

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[gabster786]

That worked! I have to manually change the first page and the vertical page break but it puts everything else where it's supposed to be so I'm good with that! thanks!!

[AlphaFrog]

That worked! I have to manually change the first page and the vertical page break but it puts everything else where it's supposed to be so I'm good with that! thanks!!

You're welcome.

You could record your "manual" steps and add the recorded macro code above the line ActiveSheet.ResetAllPageBreaks