Header & Footer

[Mark]

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

 

[Frank Kabel]

Hi Mark
use something like

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