Code to search for the next cell with zero

I use the following code to search for the next cell with a zero. But I found it stops if the value has zero contained such as 8.04, and I would like it to stop only when the value is "0".

The cell formula is an indirect reference such as =INDIRECT($A192&J$187) in which there is no data yet, so the cell shows 0

Please Login or Register  to view this content.

Is there a way to have it pass over 8.04 and stop at the cell that has only a zero contained?

Originally Posted by VBA Noob

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

PS. Best way to learn is to record the actions. Ctrl + F > options > Match entire cell content

VBA Noob

I had not even equated CNTL F (find) with this macro command - pretty dumb. I use the find features manually quite a bit. And I have recorded my actions to get at the underlaying code before.

Thanks for all the help today.