The code required to do that is very involved. I doubt if you can find any
posted code to accomplish it or get anybody to write it without charging you.

You may want to try the free trial of my commercial add-in "Special Print" which
has a 'rows to repeat at bottom' utility included.
It copies the worksheet and adds the specified row(s) to the bottom of each
page of the copied worksheet.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Mahendra"
wrote in message
Sorry...i did not put things right.
Actually I mean that I need to border each end of the page with a continuous
line. The line is to be inserted in the bottom of the last row in a page.
The program needs to find the end of the page and put a line on the last row
(bottom only) of the page.
It is nothig to do with headers or footers.
--
Mahen