Referencing page setup header information in VBA

[V C]

I am interested in inserting a formula into a cell which will populate the cell with the CenterHeader value that is already populated within Page Setup. Can someone please offer some insight into how to accomplish this? Thanks.

[shg]

Welcome to the forum.

Try recording a macro and then editing it from there.

[V C]

Thanks SHG. While recording the macro I opened the page setup screen and clicked okay. This allowed me to view the syntax of the recorded code. That was all I needed in order to come up with the needed syntax: ActiveCell.Value = ActiveSheet.PageSetup.CenterHeader. Thanks again.

[shg]

Well done, thanks for posting back with results.