Find first cell with value > 0 in a range using VBA

[anthrojames]

Hi folks,

I have a range that I would like to search through row by row until it finds the first cell with a value greater than 0. I thought of using the Range.Find method, but it seems that it only works to find a value known prior to the search. Has anyone done a task like this or have any suggestions?

Many thanks.

[xladept]

This should find it:

Please Login or Register  to view this content.

[anthrojames]

This did the trick. Thanks for the help.

[xladept]

You're welcome!