Cell Reference in Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to reference a specific worksheet cell in the header?

Thanks
 
Dave

Macro..........

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").text
End With
End Sub

Alternative........

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Text
End With
End Sub


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Referring to a portion of a column 1
How do I reference a cell to automatically update in a header 1
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
No cell references 2
Headers & Footers _auto update info from a cell in the worksheet 4
Moving worksheet references in functions 3
Custom Header - poss to link to contents of cell? 7
Why did my Excel column headers change from letters to numbers? 4

Back
Top