View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default Hide Row If Any Cell In It = 0

Hello All

Searched high and low amongst the forums for this and found some close
solutions, but can't seem to make any work.

I have Rows 1-100 & Cols A-J all with formulas or text in them. If
the result of any of the formulas in any of the that range is 0, I
want the entire row hidden.

Cheers