Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add Columns in multiple Sheets | Excel Discussion (Misc queries) | |||
Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
Insert Columns in multiple sheets | Excel Worksheet Functions | |||
Multiple Sheets and Columns | Excel Worksheet Functions | |||
Show / Hide Columns in multiple sheets | Excel Programming |