Hi Gary,

A couple questions for you:

1) Are you looking to return (find) the first value that is 0 within the
range?
2) What if there is more than one value that is 0?
3) Is the range of values sorted?

Thanks,
James

"Gary Keramidas" wrote:

what would you use in place of this to find a value in a range that's 0

rngFound =Cells.Find(What:="Your_Text", LookIn:=xlValues)

--


Gary