Excel header/footer cell reference

  • Thread starter Thread starter Guest
  • Start date Start date
Paddy

With the use of VBA, yes.

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


Gord Dibben Excel MVP
 
Via code? Yes.

You can use the workbook_beforeprint event to modify the header.

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Me.Worksheets("sheet1")
.PageSetup.CenterFooter = .Range("a1").Text
End With
End Sub

This goes behind the ThisWorkbook module.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

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

Headers & Footers _auto update info from a cell in the worksheet 4
Change Header & Footer Info w/ Worksheet Option Buttons 1
PowerPoint Separate lines (line break) - PowerPoint Footer 1
How do I reference a cell to automatically update in a header 1
How to reference a text cell that changes weekly in Header or Foo. 2
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
How do I put a specific cells information in the header or footer. 2
Filename in Excel Cell Address 7

Back
Top