I will post some code later to do that. I must rush off right now.

"mahbub" wrote:

Hi JLatham

Thanks for ur response.

Do u know, have any procedure to link two row one for header and another for
footer. I will be glad if u help my by suggestion.

Thanks

BR//

Mahbub

"JLatham" wrote:

You can have half of your wish:
Using File | Page Setup | [Sheet] tab, you can use "Rows to repeat at top"
to repeat row 1 on each page printed from that sheet, but you can't use rows
that are separated. So you could repeat rows 1 through 15, but not just rows
1 and 15.

You can, of course, use the same File | Page Setup | [Header/Footer] tab to
set up text that would be placed in the header/footer for each page printed
from that sheet.

"mahbub" wrote:

Hi

Suppose row 1 i want to use for header for everypage and row 15 which i want
to setup as a footer. is it possible in excel.

BR//

Mahbub