Excel does not recognize the concept of "page" in its object model so it
will be difficult to do it "automatically"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nd0586" wrote in message
...
i need to set up borders around pages in a long sheet of calculations
automatically. the page length varies depending on where i need page
breaks
in my calculations, and i have repeated rows at the top which i would like
the border to line up with. i am using excel 2003