View Single Post
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Use a formula on the worksheet to provide a null value or an "X" and then
filter on that column. Data, Filter

You could use advanced filter and include the formula.

More information on Filters:
http://www.contextures.com/tiptech.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tamato43" wrote in message ...
Hello everyone,

This is my second posting.

Does anyone know a VBA script to conditionally hide selected rows if they
equal zero or are left blank?

Please help.