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