Setting Bottom Border On Each Page
 

I have a long worksheet. I want the bottom line on each page to be bold. I
know I could go in and format, but then every time I change the number of
lines, I have to change the format of each page since the bottom line may
change. I really want a line that will go at the bottom of each page, like
the line at the top of each page in the print setup. Thanks for any help.

Setting Bottom Border On Each Page
 

That capability isn't inherent. You would need to use the BeforePrint event
to remove all previous bold lines, then find all the pagebreaks and format
the row above.

--
Regards,
Tom Ogilvy


"mcambrose" wrote:

I have a long worksheet. I want the bottom line on each page to be bold. I
know I could go in and format, but then every time I change the number of
lines, I have to change the format of each page since the bottom line may
change. I really want a line that will go at the bottom of each page, like
the line at the top of each page in the print setup. Thanks for any help.