Automate Page Break

[Guest]

Hello, I'm importing a Word Doc into excel that can vary from 10 rows to any
amount of rows. All data gets imported into Column A. Excel's page breaks
don't match up to how the word doc would have it's page break, therefore
making the Excel sheet less readable. The common trait of this word doc is no
matter how long or short it is, it's pagebreak would be equivalent of 49 rows
in Excel. What code could be created to automatically check to see if any
data is present in a group of 49 rows and if there is, create a pagebreak
below. There will always be data in the first 49 rows, but I would like for
it to determine the necessary pagebreaks for the subsequent sections of 49
rows. I'm familiar with VBA, but I'm no good with Loops. Your help is
appreciated.

 

[Ron de Bruin]

Hi Brad

Try this
http://www.rondebruin.nl/print.htm#Breaks

 

[Guest]

Hi Ron,

Thanks for your link. With minor tweaking of the code to suit my needs, this
works perfectly.

Thanks for the help!