Hi,
I'd like columns to be hidden based on the value in a certain row, basically if the value in say row 2 equals "N/A" the column should be hidden. It sounds relatively simple but would prefer a range type VBA code instead of having to type out each column one by one.
Thanks for reading.
Paul
I'd like columns to be hidden based on the value in a certain row, basically if the value in say row 2 equals "N/A" the column should be hidden. It sounds relatively simple but would prefer a range type VBA code instead of having to type out each column one by one.
Thanks for reading.
Paul