Greetings,
I wonder if anyone has a macro for hiding rows with zero values. It would have to look through a range in a column and then if the cell had a zero value, hide the row the cell was in.
I tried to use the AutoFilter and built a macro that selected the "blanks", but the macro won't run with the sheet protected.
Any suggestions would be most appreciated.
~SK
I wonder if anyone has a macro for hiding rows with zero values. It would have to look through a range in a column and then if the cell had a zero value, hide the row the cell was in.
I tried to use the AutoFilter and built a macro that selected the "blanks", but the macro won't run with the sheet protected.
Any suggestions would be most appreciated.
~SK