Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Hide Columns & Rows
How can I hide 1 or more columns based on a cells value
For example, If there is an X in cell A1, column F will be hidden. If there is an X in cell A2, column F will be visible. If there is an X in cell A3, column G will be hidden. If there is an X in cell A4, column G will be visible. This could be triggered by a macro. I am using Autofilter for rows I am using Excel 97. Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
Auto Hide Columns | Excel Discussion (Misc queries) | |||
auto filling columns from rows | Excel Discussion (Misc queries) | |||
Auto update entire columns / rows??? | Excel Worksheet Functions | |||
AUTO HIDE ROWS | Excel Worksheet Functions |