How do I reference a cell to automatically update in a header
in [General]
|
Prev: Anyway of accessing the internet from within excel 2007?
Next: Conditional Formatting - Dates & Blank Cells
From: Dan on 25 Feb 2010 22:50 How do I reference a cell in a worksheet to automatically report in a header or a footer.
From: מיכאל (מיקי) אבידן on 26 Feb 2010 03:33
I believe it could be accomplished with an Event-Macro at the sheets level. Assuming B5 Text should be reflected as the Header - try this: ------------------------------------------------------------ Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$5" Then ActiveSheet.PageSetup.CenterHeader = [B5] End If End Sub ------------- Micky "Dan" wrote: > How do I reference a cell in a worksheet to automatically report in a header > or a footer. |