Any ideas why this simple proc. won't work?
I get a Compile Error: Invalid Outside Procedure error, and the
debugger highlights the sheet name in the Shtarray "Dom P&L Ship".
I'm obviously screwing up syntax somewhere! Thanks!
Public Shtarray As Sheets
Public sht As Worksheet
Shtarray = Array("Dom P&L Ship", "Cons P&L Ship")
Sub ShowAnnually2003()
For Each sht In Shtarray
Workbook.Sheet(sht).Columns("A:D").EntireColumn.Hi dden = True
Next
End Sub
|