Hide columns & rows that contain "0" or blank in a range of cells
 

I need a macro to hide rows 21 through 54 and columns I through BP if
there are either zeros or blanks in the cells I21:BP54. I am new at
this macro stuff, and could really use some help. Thanks in
advance.... :confused:


--
lw new guest
------------------------------------------------------------------------
lw new guest's Profile: http://www.excelforum.com/member.php...o&userid=26418
View this thread: http://www.excelforum.com/showthread...hreadid=396872