So I'm trying to get footers attached to a dynamic sheet list.
On a tab, I have the sheet names in cells that I want to attach footer as a named range (called Sheet_List) such as:
A1: Page_1
A2: Page_2
etc.
In VBA, I was wondering if I can refer to the named range "Sheet_List" to attach footers instead of typing in the sheet names in the code. Right now, I have
For Each ws In Array(Sheets("Page_1"), Sheets("Page_2"))
ws.PageSetup.LeftFooter = "Stuff"
On a tab, I have the sheet names in cells that I want to attach footer as a named range (called Sheet_List) such as:
A1: Page_1
A2: Page_2
etc.
In VBA, I was wondering if I can refer to the named range "Sheet_List" to attach footers instead of typing in the sheet names in the code. Right now, I have
For Each ws In Array(Sheets("Page_1"), Sheets("Page_2"))
ws.PageSetup.LeftFooter = "Stuff"