View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ell7 ell7 is offline
external usenet poster
 
Posts: 8
Default 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!!