J
JB2005
Any ideas how we could;
Starting from a row (say 10) and for each subsequent row, to last row of
used range;
If cell value in column C of the row = 0, then hide the row (if not already
hidden).
If cell value in column C of the row > 0, then unhide the row (if hidden).
To make it more interesting;
Only read the first row of any row grouping and hide/unhide all the rows in
that group, based on the condition of the first row.
Starting from a row (say 10) and for each subsequent row, to last row of
used range;
If cell value in column C of the row = 0, then hide the row (if not already
hidden).
If cell value in column C of the row > 0, then unhide the row (if hidden).
To make it more interesting;
Only read the first row of any row grouping and hide/unhide all the rows in
that group, based on the condition of the first row.