referencing a cell within a header

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peekabeaux - 25 Jan 2006 22:16 GMT

Is there a way to reference a cell's value in a header? I have a time card
that within the header is a pay ending from and to date that I must manually
fill out (argh!). Since the information is already in the spreadsheet every
week,[ always B5 and F5 ] I would like to be able to reference those cells
within my header.
Thanks for any answers.
Peekabeaux

Reply to this Message

Ron de Bruin - 25 Jan 2006 22:24 GMT

Hi

Try this example

With ActiveSheet.PageSetup
.RightHeader = "text " & Range("B5").Value & " again text " & Range("F5").Value
End With

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Is there a way to reference a cell's value in a header? I have a time card
> that within the header is a pay ending from and to date that I must manually
[quoted text clipped - 3 lines]
> Thanks for any answers.
> Peekabeaux

Reply to this Message