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

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




.