Custom Footers
Hey,
I need to have Printed By:________ 06Aug04 on the same
line in the RightFooter.
Sub Dates()
ActiveSheet.PageSetup.RightFooter = "Printed By:_______"
ActiveSheet.PageSetup.RightFooter = Format(Now, "dd mmm
yy")
End Sub
No matter how I have tried to break this up different ways
it will either give me the Printed By or the date but not
both.
Any and all help would be appreciated.
Thanks,
Charmaine
|