find syntax help please
Find looks for text or number matches. It does not look for conditions such
as greater than or less than . You will want to traverse through the cells
individually and use an if statement to do the comparison.
--
HTH...
Jim Thomlinson
"Gary Keramidas" wrote:
can someone help me with this. i had it somewhere and can't remember. i want to
find values in a column <=0.
is it something like this?
Find(What:="<=0", LookIn:=xlValues)
--
Gary
|