Insert a line at the bottom page

[Mahendra]

I need to insert a line at the bottom page using macro programming.

 

[paul.robinson]

Hi
Not clear enough.
Could mean
1. Insert text into the bottom line on the sheet when it prints out
2. Insert text into the footer below the main page text
3. Insert a new blank row into the excel sheet below a block of data
4. Insert a row and text into the excel sheet below a block of data

Other people may think of other things your question might mean.
What do you mean exactly?

regards
Paul

 

[Mahendra]

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.

 

[Jim Cone]

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.