Hi Ron,

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

Thanks for the help!

"Ron de Bruin" wrote:

> Hi Brad
>
> Try this
> http://www.rondebruin.nl/print.htm#Breaks
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Brad" <Brad@discussions.microsoft.com> wrote in message news:FC5F72DB-5ADA-492E-8DC9-6E34C361A8E8@microsoft.com...
> > 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.
>
>
>