I think I'd just cycle through those worksheets

dim wks as worksheet
for each wks in worksheets(Array("04-329", "04-350", "05-001", "05-353", _
"05-354", "06-011", "06-012", "06-013"))

wks.range("H:H,L:U").EntireColumn.Hidden = True
next wks

GregR wrote:

I am using this code to hide columns on multiple sheets:

Sheets(Array("04-329", "04-350", "05-001", "05-353", "05-354",
"06-011", "06-012", _
"06-013")).Select
Sheets("04-329").Activate

Range("H:H,L:U").Select
Range("S1").Activate
Selection.EntireColumn.Hidden = True

It works on the first sheet, but only selects the columns in the
remainder and does not hide them. What do I need to change to hide the
selection on all the sheets. TIA

Greg

--

Dave Peterson