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.