Multiple sheets PageSetup

[thecdnmole]

Trying to use this to pagesetup only certain sheets in a workbook, but get Runtime error 9, Subscript out of range using this code. It faults out on the Sheets(Array... line. Can someone help? Thanks.

Please Login or Register  to view this content.

[protonLeah]

Put Option Explicit at the top of the module and debug. Do you get a "variable not defined error" highlighting one of the sheets?

[thecdnmole]

Hi Ben, I have Option Explicit already. Now I get "Run time error 1004" and "Select method of sheets class failed".

[protonLeah]

In this case, "Subscript out of range" may mean that either Sheet1, Sheet2 or Sheet3 has been deleted (and a new sheet added with the old tab nae). Do You see those exact sheets in project view? Does the code run if you replace Sheet.name with the tab name?

[thecdnmole]

In this case, "Subscript out of range" may mean that either Sheet1, Sheet2 or Sheet3 has been deleted (and a new sheet added with the old tab nae). Do You see those exact sheets in project view? Does the code run if you replace Sheet.name with the tab name?

Yes, those sheets are there, if I hover over sheet#.name it shows the sheet name. No, it does not run if I replace sheet.name with worksheet name. Puzzling, cause it works in another workbook.