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

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.

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

"serdar" <serdarsoy@xxxxxxxxx> wrote in message
news:uSmEJXTkFHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
>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@xxxxxxxxxxx>, haber iletisinde þunlarý
> yazdý:#$ZvY8GkFHA.2920@xxxxxxxxxxxxxxxxxxxxxxx
>> 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 ***, but a macro can put cell contents into the custom footer.
>> --
>> Earl Kiosterud
>> www.smokeylake.com
>>
>> "serdar" <serdarsoy@xxxxxxxxx> wrote in message
>> news:uSvD8sEkFHA.576@xxxxxxxxxxxxxxxxxxxxxxx
>> >I can define the header but not the footer. How to do this?
>> >
>> >
>>
>>
>
>


.