How do i include the contents of a spreadsheet cell in the footer?

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

Guest

if i have "TEST" in cell A1, i want to include that cell contents in the
footer. if the cell contents changes, then i want it to automatically change
in the footer. haven't been able to find a way.
 
Not sure of a few issues here, is this just for printing? Do you want it to
put cell A1 only when "test" is there or anything? This can be modified for
you knowing answers to the above. This puts cell A! value in the left footer
just before pringt
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets(1).PageSetup.LeftFooter = Sheets(1).Cells(1, 1)

End Sub
 

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

Can I link a cell's contents to the header or footer in Excel? 14
How do I use an Excel cell in footer 2
How do I copy cell contents to footer in Excel 1
Headers & Footers _auto update info from a cell in the worksheet 4
Create a Standard Footer 2
Display cell contents in the Header or Footer? 1
How to Include a specific Cell's Contents in a footer Excel 2003 1
How do I enter the contents of a cell into a page header 1

Back
Top