View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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.