| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to hide/unhide columns
PERFECT!!!!!
Thanks to both of you for the help. "Die_Another_Day" wrote: Once all columns are selected press Ctrl+Shift+) to unhide all columns. Charles Chickering xl Geek Monique wrote: My thought was that I could select all the columns in my spreadsheet and run the macro to unhide columns. This should unhide all columns. This is what I need anyway, because I would need to select a new set of columns to hide for the next step in my process. Can or should I turn your macro statement into an if/then statement? "Bob Phillips" wrote: For Each col In Selection.Columns col.Hidden = True Next col will hide them, but how will you select hidden columns? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Monique" wrote in message ... I need to hide and unhide columns in a spreadsheet. My problem is that different sets of columns are being hidden depending on the data I need. I can create a basic macro, but can't seem to get it to work when I select more than one column (either a range or non consecutive sets [i.e. columns C and E or C,D, and F, etc]). Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Hide-Unhide Columns with a macro | Excel Discussion (Misc queries) | |||
| Auto Hide-Unhide Columns with a macro | Excel Discussion (Misc queries) | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
| How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) | |||
| Macro to hide or unhide columns | Excel Programming | |||
Hybrid Mode
