Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, with special bow to Bob and Frank :)
I re-clarify my previous post: Task at hand is to hide a dozen columns i a "Main" sheet. - it has many more of them. I listed headings of interesting columns, stored them in 1 column vertical list and named it "Elements" (stored on separate sheet) I need effcient metod of parsing header row of the sheet and change column width to 0 of those that match "Elements" I think I saw a 1-liner or so for the task. I used to do full 2 range looping - but it's 21st century, so I figure I gotta move ahead... :) TIA Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
Hiding columns | Excel Discussion (Misc queries) | |||
(repost) Listbox Rowsource Headings Multi columns | Excel Programming | |||
Not Hiding Columns | Excel Programming |