Header & Footer
 

I am using Excel 97.

Is there a way to capture the contents of the
CenterHeader & CenterFooter on a worksheet and use them
programmatically in VBA elsewhere?

If so, can someone assist with some code, please?

Regards


Mark

Header & Footer
 

Hi Mark
use something like

sub foo()
dim vfooter
with activesheet.pagesetup
vfooter=.centerfooter
end with
msgbox vfooter
end sub


--
Regards
Frank Kabel
Frankfurt, Germany


Mark wrote:
I am using Excel 97.

Is there a way to capture the contents of the
CenterHeader & CenterFooter on a worksheet and use them
programmatically in VBA elsewhere?

If so, can someone assist with some code, please?

Regards


Mark