Cell reference in header

T

Terry Bennett

I'm sure there is a way of doing this but I haven't been able to figure it
out ...

I want to include some variable text in a sheet header - the text being
contained in a cell within the same workbook. I can find ways of including
the sheet name or file name in the header but not a specific cell's
contents.

Can somebody point me in the right direction?

Thanks.
 
G

Gord Dibben

Terry

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP
 
T

Terry Bennett

Many thanks Gord!


Gord Dibben said:
Terry

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I Reference another cell's content including its format 2
Header or Footer - Reference a Cell 5
How could I display an excel cell contents in a page header ? 1
EXCEL: find string in vector & return cell reference 1
How to reference another cell based on what row a certian header i 2
nested Cell("contents", w/ cell contents reference) 1
find cell with matching text, then reference cell in same row 2

Top