| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find syntax help please
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find syntax help please
ok,thanks, jim.
i think it's coming back to me. i saw something like this for criteria in an autofilter statement, not a find statement. -- Gary "Jim Thomlinson" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find syntax help please
You may be able to limit the range to search by using .specialcells and look for
numbers. The look for the - (minus sign) in the values. Gary Keramidas wrote: ok,thanks, jim. i think it's coming back to me. i saw something like this for criteria in an autofilter statement, not a find statement. -- Gary "Jim Thomlinson" wrote in message ... 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where can I find the syntax and semantics for expressions in Excel 2003 headers and footers? | New Users to Excel | |||
| Correct find syntax | Excel Programming | |||
| Excel97 - Syntax for Find, Offset, Insert Page | Excel Programming | |||
| Find method syntax | Excel Programming | |||
| Macro syntax - how to find them | Excel Programming | |||
Linear Mode
