T
turbogreg17
Please help, I’ve searched for the answer, but my problem seems to be unique.
Here is the background: I have a spreadsheet with many, many columns of data
(“E†through “EO†as of today, and it keeps growing). I have 9 rows of data
(rows 3 -12), so the area I’m concerned with as of today spans E3:EO12. The
cells are either blank or contain a “X†(just two choices).
I want to hide every column that contains an “X†in each of its rows (i.e.
if every cell in “E3:E12†contains “Xâ€, then hide “Eâ€, same for column “Fâ€,
“Gâ€, etc.). If any one of the rows in a column is blank, I need to see the
column. I just can’t get the syntax right for the macro.
I thought about redoing the macro code for each column, but there has to be
a better way. And it would be a bit cumbersome as I continue to add columns.
Can someone please help? Thanks. Greg
Here is the background: I have a spreadsheet with many, many columns of data
(“E†through “EO†as of today, and it keeps growing). I have 9 rows of data
(rows 3 -12), so the area I’m concerned with as of today spans E3:EO12. The
cells are either blank or contain a “X†(just two choices).
I want to hide every column that contains an “X†in each of its rows (i.e.
if every cell in “E3:E12†contains “Xâ€, then hide “Eâ€, same for column “Fâ€,
“Gâ€, etc.). If any one of the rows in a column is blank, I need to see the
column. I just can’t get the syntax right for the macro.
I thought about redoing the macro code for each column, but there has to be
a better way. And it would be a bit cumbersome as I continue to add columns.
Can someone please help? Thanks. Greg