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
.