Header / Footer Formula

[plans]

Hello,
I know there are ways to change the Header / Footer content through a macro but I am trying to do this through a formula when the values are stored in a specific cell in the workbook; for example, I have a Range called "MyName", I want to use in the header a formula like &[MyName] or something similar.
Is this possible?
Thanks

[6StringJazzer]

No. There are no codes you can use in a header or footer that reference cells or named ranges. It requires a macro.