Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying Page Breaks
Is there a way to easily tell if a range (i.e., cell) is
adjacent to a page break? At every page break, I would like to insert some text but I don't know how to determine if the range object is adjacent to a page break (without creating one manually). Thanks, Seth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying Page Breaks
I can't use footers in this case.
Your solution is exactly what I was looking for! I just needed to be pointed in the right direction Thanks! Seth -----Original Message----- Seth, if u cant/wont use Footers? then have a look at HPageBreaks collection object in VBA help endif keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Seth" wrote: Is there a way to easily tell if a range (i.e., cell) is adjacent to a page break? At every page break, I would like to insert some text but I don't know how to determine if the range object is adjacent to a page break (without creating one manually). Thanks, Seth . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
When automatic page breaks are moved each cell becomes a new page | Excel Discussion (Misc queries) | |||
Vertical page breaks won't drag in Page Break Preview | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
How do I remove a page 1 watermark identifying each page that wil. | Excel Discussion (Misc queries) |