Darran, have a look at data filter auto filter and custom ,is less than or
equal to 0

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Darran Caputo" wrote in message
om...
Is there a way to hide rows in a worksheet based on a value in the row?

In other words:


IF A1 0 then "Hide Row"