View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Add a dynamic date to a header or footer

ActiveSheet.PageSetup.LeftHeader = "ABCD"
works fine in Excel.

Apparently you are not implementing it correctly within the context of your
code.

--
Regards,
Tom Ogilvy

Lakshmana Ravula wrote in message
...

Thank You Tom Ogilvy
But This is giving an error 438: Object doesnt support this property or
method
Regards
Lakshmana


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!