Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insertnew worksheet page
I have a 4 column worksheet sorted by column A (product name). there are
3000 records in the worksheet. I need to create a page break based on a change of the value in Collumn A. The ultimate destination of the results will be insertion into a word document with a page break between each separate "table". any assistance onhow to achieve the above is greatly appreciated. My skill level in excel is moderate beginner... thank you - Ellen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insertnew worksheet page
Sub Insert_PBreak()
Dim OldVal As String Dim rng As Range OldVal = Range("A1") For Each rng In Range("A1:A3000") If rng.text < OldVal Then rng.PageBreak = xlPageBreakManual OldVal = rng.text End If Next rng End Sub Note............with 3000 cells to look at, will take a while because pagebreak insertion is a slow process. Gord Dibben MS Excel MVP On Mon, 25 Aug 2008 13:04:02 -0700, nellellen wrote: I have a 4 column worksheet sorted by column A (product name). there are 3000 records in the worksheet. I need to create a page break based on a change of the value in Collumn A. The ultimate destination of the results will be insertion into a word document with a page break between each separate "table". any assistance onhow to achieve the above is greatly appreciated. My skill level in excel is moderate beginner... thank you - Ellen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page numbers on copies of a single page worksheet | Excel Discussion (Misc queries) | |||
change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
Converting a muliple page worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
Page 1, Page 2, ...is showing up very large in the worksheet. | Excel Discussion (Misc queries) | |||
why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) |