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
Bookmarks