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