K
Karissa
I am trying to get a header in excel to reference to a cell in a different
sheet. Is that possible? Thanks!
sheet. Is that possible? Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
Here is some VBA that will do it:
Sub UpdateHeader()
ActiveSheet.PageSetup.LeftHeader = Range("Sheet4!G2").Value
End Sub
See:
XL2000: How to Reference a Cell in the Header or Footer
http://support.microsoft.com/default.aspx/kb/273028
If new to VBA visit David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
Sub UpdateHeader()
ActiveSheet.PageSetup.LeftHeader = Range("Sheet4!G2").Value
End Sub
See:
XL2000: How to Reference a Cell in the Header or Footer
http://support.microsoft.com/default.aspx/kb/273028
If new to VBA visit David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
I
ilia
I am trying to get a header in excel to reference to a cell in a different
sheet. Is that possible? Thanks!
Supposing the cell on a different sheet is A1 and the different sheet
itself is called Sheet2, use this formula:
='Sheet2'!A1
I
ilia
Oh you meant page header, not column header... sorry.
K
Karissa
I do mean page header, sorry I wasn't clear. Does anyone know how to do that?
B
Bernard Liengme
Only with VBA as in my first message.
K
Karissa
Thank you, I really appreciate your help!
Bernard Liengme said:Only with VBA as in my first message.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email