| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format column auto. to "hidden"
How do I set up an automatic column format to "zero" width
or hidden. What I want to do is when a particular cell has a certain value I want another column or row to hide itself and when the cell is changed to another value the column will show up again. I have looking through various excel developer books and cannot seem to find the answer. I even tried a macro and still could not get it to work. In other words, if cell j5 = x (text) or a number - lets say 5 then column "b" goes to hidden or zero width --- then when cell j5 is not the x or 5 column "b" goes back to normal and is seen! P.S. same for rows as well! I hope you can help! Thanks, Nils |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
| Auto Filter - how to collapse "non-blank" cells in a column? | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| How do I get "auto sum" to subtract hidden cell values from total | Excel Worksheet Functions | |||
| How do I get a column to "auto fill" in a pivot table? | Excel Discussion (Misc queries) | |||
Threaded Mode
