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
 
Back
Top