Thread: Custom Footers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charmaine Charmaine is offline
external usenet poster
 
Posts: 1
Default 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