Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Page Break
Hi Brad
Try this http://www.rondebruin.nl/print.htm#Breaks -- Regards Ron de Bruin http://www.rondebruin.nl "Brad" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Page Break
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
how to automate page break | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |