Excel, how to obtain Header/Footer values

[RCDD]

I need to retrieve the value of right footer of many excel files. The reason is to get the value and then,modify substring, and write back into it.

For example, I know how to assign right footer value.
ActiveSheet.PageSetup.RightFooter = "TEST123"

But, I can't figure out how to get the pre-entered right footer out?

 

[IRstuff]

Just do the reverse:

footval = ActiveSheet.PageSetup.RightFooter

TTFN

 

[RCDD]

It works. I apologize for not so smart post. I'm 99% sure I tried it and got an error message ... hum.. I guess I'm getting old. Thanks IRstuff.

 

[IRstuff]

No worries. I find VBA a bit squirrelly and nonintuitive quite often.

TTFN