Adding current date and contents of a cell in the footer
As far as I know this can be done only via VBA:
Sub lfooter()
ActiveSheet.PageSetup.LeftFooter = "&D" &
Sheets("Registration").Range("B7")
End Sub
You can insert this custom footer also directly via VBA Immediate window.
Regards,
Stefi
€˛Carl€¯ ezt Ć*rta:
Is there a way to add the current date AND the contents of a certain cell in
the footer? I tried entering the following in the customized footer section
to no avail:
&[Date], [Sheets("Registration").Range("B7")]
Thanks in advance.
|