Hello, I would like to create both a Header and a Footer on 224 individual spreadsheets. Scripting it rather than doing it by hand appeals, for obvious reasons. For the life of me, though, I can’t figure out how to call the Header/Footer object, or what command will then insert text into it. I tried assigning the Page Setup object to a Variable and pasting the clipboard contents to that Variable. Although that compiled, instead of opening the Header and pasting to it, it pasted to whatever cell my pointer was on at the time. Can anybody help with Headers/Footers?
Thank you.