| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a cell within a header
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a cell within a header
Hi
Try this example With ActiveSheet.PageSetup .RightHeader = "text " & Range("B5").Value & " again text " & Range("F5").Value End With -- Regards Ron de Bruin http://www.rondebruin.nl "Peekabeaux" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing A Row Header Containing a Slash | Excel Discussion (Misc queries) | |||
| Referencing Cell Next To Today's Date Cell | Excel Discussion (Misc queries) | |||
| Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
| Header and cell referencing | Excel Discussion (Misc queries) | |||
| Referencing a cell in the header | Excel Programming | |||
Linear Mode
