Hiding rows containing zero in certain column on multiple sheets
 

Hiya - I hope you can help

I have a table on which I would like to hide selected rows should the
value in a certain column be zero (say, I would like to hide rows
5,10,16,17 & 18 if their value in column M is zero). I have the table
on multiple worksheets (say Sheet1, Sheet2, Sheet3 & Sheet4). The
table is exactly the same on each sheet, but the data is different so
different rows will be hidden.

How can I do this with coding? I am more or less a novice on this. My
experience is pretty much limited to using the macro recorder. Any
help would be very much appreciated. Thanks!!

Hiding rows containing zero in certain column on multiple sheets
 

Why not just use an auto filter? That seems a lot easier. If you still need a
code solution then just let me know...
--
HTH...

Jim Thomlinson


"ell7" wrote:

Hiya - I hope you can help

I have a table on which I would like to hide selected rows should the
value in a certain column be zero (say, I would like to hide rows
5,10,16,17 & 18 if their value in column M is zero). I have the table
on multiple worksheets (say Sheet1, Sheet2, Sheet3 & Sheet4). The
table is exactly the same on each sheet, but the data is different so
different rows will be hidden.

How can I do this with coding? I am more or less a novice on this. My
experience is pretty much limited to using the macro recorder. Any
help would be very much appreciated. Thanks!!