Header & Footer

M

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
 
F

Frank Kabel

Hi Mark
use something like

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