I'm using find command on a discontinuous range. (its the union of 4-5
ranges) Is there anyway to find all the cells in the range with a length
of 3 without just using FindNext and checking if it's len 3? I'm looking
for something like:

FirstFound = Quadrants(n).Find(what:=LENGTH=3, etc. etc.
SecondFound = Quadrants(n).FindNext(FoundFirst)

Since its numbers I could also use val 99<1000


It would save a lot of looping time

John

Use "???" as your What argument and xlWhole as the LookAt argument. Assuming
Quadrants is an array of Ranges, something like this...

Set FirstFound = Quadrants(n).Find(What:="???", LookAt:=xlWhole, etc.)
Set SecondFound = Quadrants(n).FindNext(FoundFirst)

--
Rick (MVP - Excel)


"John" wrote in message
...
I'm using find command on a discontinuous range. (its the union of 4-5
ranges) Is there anyway to find all the cells in the range with a length
of 3 without just using FindNext and checking if it's len 3? I'm looking
for something like:

FirstFound = Quadrants(n).Find(what:=LENGTH=3, etc. etc.
SecondFound = Quadrants(n).FindNext(FoundFirst)

Since its numbers I could also use val 99<1000


It would save a lot of looping time

John

Perfect. Thanks. Have to remember to reset the xlWhole to part in later
finds.

What other things can you put in the What:? Are there other wildcards?
Is it possible to have a range of values? Like find anything between 2
and 20? Or where on the web could I find more about it.

John

Rick Rothstein wrote:
Use "???" as your What argument and xlWhole as the LookAt argument.
Assuming Quadrants is an array of Ranges, something like this...

Set FirstFound = Quadrants(n).Find(What:="???", LookAt:=xlWhole, etc.)
Set SecondFound = Quadrants(n).FindNext(FoundFirst)