How to define specific cells as header and footer for printing?

I can define the header but not the footer. How to do this?

Serdar,

I think you're confusing "Rows to repeat at top" with the custom header,
both in File - Page Setup. Rows defined as rows to repeat at top only
appear at the top of the printed page. For stuff to appear at the bottom of
every page, you can use the custom footer. You can't link it to cells in
the sheet, but a macro can put cell contents into the custom footer.
--
Earl Kiosterud
www.smokeylake.com

"serdar" <serdarsoy@yahoo.com> wrote in message
news:uSvD8sEkFHA.576@tk2msftngp13.phx.gbl...
>I can define the header but not the footer. How to do this?
>
>

I just thought this repeating rows fits my goal but it seems not now.
I can only use range of cells as footer by macros, right? I am helping a
friend and he does not have a good VB knowledge so he cannot use macros.
Well that's ok i help him writing a macro if he insists on. Thanks.


"Earl Kiosterud" <someone@nowhere.com>, haber iletisinde şunları
yazdı:#$ZvY8GkFHA.2920@TK2MSFTNGP14.phx.gbl...
> Serdar,
>
> I think you're confusing "Rows to repeat at top" with the custom header,
> both in File - Page Setup. Rows defined as rows to repeat at top only
> appear at the top of the printed page. For stuff to appear at the bottom
of
> every page, you can use the custom footer. You can't link it to cells in
> the sheet, but a macro can put cell contents into the custom footer.
> --
> Earl Kiosterud
> www.smokeylake.com
>
> "serdar" <serdarsoy@yahoo.com> wrote in message
> news:uSvD8sEkFHA.576@tk2msftngp13.phx.gbl...
> >I can define the header but not the footer. How to do this?
> >
> >
>
>

Serdar,

> I can only use range of cells as footer by macros, right?

Yes. The macro would have to actually put the cell contents into the
footer; Excel has no provision for putting cells in the footer. Rows to
repeat at top puts rows at the top of the page, below the page header.

ActiveSheet.PageSetup.CenterFooter = Range("A1")
--
Earl Kiosterud
www.smokeylake.com

"serdar" <serdarsoy@yahoo.com> wrote in message
news:uSmEJXTkFHA.3144@TK2MSFTNGP12.phx.gbl...
>I just thought this repeating rows fits my goal but it seems not now.
> I can only use range of cells as footer by macros, right? I am helping a
> friend and he does not have a good VB knowledge so he cannot use macros.
> Well that's ok i help him writing a macro if he insists on. Thanks.
>
>
> "Earl Kiosterud" <someone@nowhere.com>, haber iletisinde şunları
> yazdı:#$ZvY8GkFHA.2920@TK2MSFTNGP14.phx.gbl...
>> Serdar,
>>
>> I think you're confusing "Rows to repeat at top" with the custom header,
>> both in File - Page Setup. Rows defined as rows to repeat at top only
>> appear at the top of the printed page. For stuff to appear at the bottom
> of
>> every page, you can use the custom footer. You can't link it to cells in
>> the sheet, but a macro can put cell contents into the custom footer.
>> --
>> Earl Kiosterud
>> www.smokeylake.com
>>
>> "serdar" <serdarsoy@yahoo.com> wrote in message
>> news:uSvD8sEkFHA.576@tk2msftngp13.phx.gbl...
>> >I can define the header but not the footer. How to do this?
>> >
>> >
>>
>>
>
>