An easy way to do this would be to use the auto filter feature,
Data-Filter-Auto Filter. Then within each filter choose "(NonBlanks)".

Does that help?
--
Regards,

Dave


"lw new guest" wrote:


How can I hide rows 21 through 54 and Columns I through BP when the
entire row/column is either 0 or blank between I21 and BP54?

Thanks,
Lynn


--
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=396901