| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows/colums by value
HIDING
I'd like to be able to hide various rows and columns that have the number 1 in their first position. For example: If A4 =1 then hide row 4. If B6=1 then hide column B. I'm okay with never being alble to hide row 1 or column A so there shouldn't be any conflict/ambiguity. UNHIDING I'm happy to just unhide all when I need to unhide any. How can I do that? Would someone point me in the right direction? Thanks for any help. /e |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide data in specific rows/colums/cells in Excel 2003 | Excel Discussion (Misc queries) | |||
| Chart disappears if you hide rows/colums with data. | Excel Discussion (Misc queries) | |||
| Macro to Hide Colums | Excel Programming | |||
| macro total for colums with changing # of rows | Excel Programming | |||
| What is the quickest way to hide a lot of rows and colums ? | Excel Discussion (Misc queries) | |||
Threaded Mode
