Can't you use auto filter and use a custom filter of greater than 0
--
intruder9
------------------------------------------------------------------------
intruder9's Profile:
http://www.excelforum.com/member.php...o&userid=30107
View this thread:
http://www.excelforum.com/showthread...hreadid=497913