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
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"specialist" wrote:

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.