Footer = cell

blacktour

Board Regular
Joined
May 24, 2005
Messages
219
Is there any way to make a footer look for data in a cell?

So if at anytime cell a1 changes the footer changes as well without using a macro?

Thanks,
Mike
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening blacktour

You can do this from Excel 2002. In versions of Excel pre 2002, without a macro, no.

HTH

DominicB
 

cfree36

Board Regular
Joined
Oct 5, 2005
Messages
175
Why wouldn't you want to use a macro to get the desired result?

Sub CustomFooter1()
' Inserts formula result from cell into the page footer
' for each sheet in the active workbook
For Each sht In ActiveWorkbook.Sheets
sht.PageSetup.CenterFooter = Range("A1")
Next sht
End Sub
 

Forum statistics

Threads
1,077,783
Messages
5,336,304
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top