View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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