Add a dynamic date to a header or footer
 

Hi Any body

While handling a Excel spresd sheet Through VB I need to
input the headings and dates Dynamically called from a
function or cell in to page header or Page footer. How
this customisation of Page heder is possible.

Thank you
Lakshmana

Add a dynamic date to a header or footer
 

ActiveSheet.PageSetup.LeftHeader = "ABCD"

also CenterHeader, RightHeader, Leftfooter, CenterFooter, RightFooter

--
Regards,
Tom Ogilvy

"Lakshmana" wrote in message
...
Hi Any body

While handling a Excel spresd sheet Through VB I need to
input the headings and dates Dynamically called from a
function or cell in to page header or Page footer. How
this customisation of Page heder is possible.

Thank you
Lakshmana

Add a dynamic date to a header or footer
 

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!

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!