K
Kevin
I need some help writing some code to hide entire rows and
columns based upon values of cells. I have about 1000
rows and about 25 columns to check to see if the columns
or row should be displayed or hidden.
For example if z10 = "xxx" I'd like to hide the entire
row from view
then check z11 = "xxx" and hide that row and so on for
about 1000 rows
I'd need the same type of loopin code for my 25 columns.
Values change in all the cells, so there may be times
where the cells contain data and I'd want the row to be
displayed. Other times there won't be data and I just
want to hide that row. This way only the row/column
combinations that have the data I want to see will be
displayed.
thanks.
columns based upon values of cells. I have about 1000
rows and about 25 columns to check to see if the columns
or row should be displayed or hidden.
For example if z10 = "xxx" I'd like to hide the entire
row from view
then check z11 = "xxx" and hide that row and so on for
about 1000 rows
I'd need the same type of loopin code for my 25 columns.
Values change in all the cells, so there may be times
where the cells contain data and I'd want the row to be
displayed. Other times there won't be data and I just
want to hide that row. This way only the row/column
combinations that have the data I want to see will be
displayed.
thanks.