Automate Page Break

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.

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.

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.
>
>
>