I am trying to create a spreadsheet whereby I want to repeat rows at both the
top and bottom of each page. The top I have sorted, although I need to
automatically put a gridline across the bottom of the page. Can anyone help
please

There is no way to repeat a row (or rows) at the foot of a page. You can
only use View | Headers & Footers to add a footer. Some one more versed in
VBA may prove me wrong with rows at bottom.

Non Brits: Debbie means she as 'sort out' not 'put in some order' when she
says she has 'the top sorted'

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Debbie Iles" <Debbie wrote in message
...
I am trying to create a spreadsheet whereby I want to repeat rows at both
the
top and bottom of each page. The top I have sorted, although I need to
automatically put a gridline across the bottom of the page. Can anyone
help
please