Inserting a cell in the header.

S

Stormy

We are trying to get a cell in the header of a sheet. Can this be done?
Example would be in our sheet in D9 is TFF. We want whatever is in D9 to go
in the header. I'm not sure this makes sense.
Thanks
Wendy
 
M

mrice

You could do this with a macro linked to the worksheet_change event.

Insert the following code into the macro sheet for the sheet with the
cell if interest.

Private Sub Worksheet_Change(ByVal Target As Range)
For Each Cell In Target
If Cell.Address = "$D$9" Then
ActiveSheet.PageSetup.CenterHeader = Cell.Value
End If
Next Cell
End Sub
 
Top