Functions in the footer?

  • Thread starter Thread starter Haydie-lady
  • Start date Start date
H

Haydie-lady

Is there a way to reference a cell in the footer? I want it to equal cell(s)
in that sheet or another sheet in that book.
 
Hi,

No. However you can run code to do that:


The following code puts the contents of cell A1 of Sheet1 into the left
headere:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("A1")
End Sub

1. To add this code to your file, press Alt+F11,
2. In the VBAProject window, top left side, find thisWorkbook under your
file name and double click it.
3. Paste in or type the code above.
 
I can't get it to work, but I don't work with codes very often either. bummer
 
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

Headers & Footers _auto update info from a cell in the worksheet 4
Excel Unique last page footer 1
Header and Footer 5
PowerPoint Separate lines (line break) - PowerPoint Footer 1
Footer limitation 3
Excel startup 5
Footer 1
transferring headers and footers 1

Back
Top