Setting Bottom Border On Each Page

[Guest]

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.

 

[Guest]

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.