| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
detecting a vertical page break
hi,
is there anyway to detect a vertical pagebreak that excel generates this is needed to be able to repeat a 'title' value in a cell right after the vertical page break i can't use the page title for it since the title changed every x columns so what i'm looking for is some kind of formula wich i can repeat in every cell on the title row that will look for a pagebreak and if so will repeat a value from a specific cell tia, marc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
detecting a vertical page break
xlPageBreakAutomatic
See VBA help: PageBreak Lars Kofod Denmark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vertical page breaks won't drag in Page Break Preview | Excel Discussion (Misc queries) | |||
| detect when columns being written to a worksheet “cross” a vertical page break | Excel Worksheet Functions | |||
| How do I remove unnecessary vertical page break? | Excel Worksheet Functions | |||
| Removing A Vertical Page Break That Won't Go! | New Users to Excel | |||
| vertical page break | Excel Discussion (Misc queries) | |||
Linear Mode
