match vs find question
 

right now i'm using find to search a row of values for an item, if it find it, i
use the rngfound row to enter some data below. if it doesn't find it, it adds an
item to the range.

i could use application.match to return the position, too, so i'm just wondering
if one way is preferred over the other.

--


Gary

match vs find question
 

I would guess that Find is aesthetically better, as it is not Excel
dependent, and has more flexibility in the search pattern and then looking
for next. Match scores if you want to do a nearest value find. Horses for
courses I guess. I tend to use Application.Match in responses I give, but I
actually use Find more in my own code.

I have no idea if one is faster ( I would guess Find), never had the need to
time it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
right now i'm using find to search a row of values for an item, if it find
it, i use the rngfound row to enter some data below. if it doesn't find
it, it adds an item to the range.

i could use application.match to return the position, too, so i'm just
wondering if one way is preferred over the other.

--


Gary

match vs find question
 

thanks for the response, bob.

--


Gary


"Bob Phillips" wrote in message
...
I would guess that Find is aesthetically better, as it is not Excel dependent,
and has more flexibility in the search pattern and then looking for next. Match
scores if you want to do a nearest value find. Horses for courses I guess. I
tend to use Application.Match in responses I give, but I actually use Find more
in my own code.

I have no idea if one is faster ( I would guess Find), never had the need to
time it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
right now i'm using find to search a row of values for an item, if it find
it, i use the rngfound row to enter some data below. if it doesn't find it,
it adds an item to the range.

i could use application.match to return the position, too, so i'm just
wondering if one way is preferred over the other.

--


Gary

match vs find question
 

Another point I forgot to mention Gary is that Application.Match is useful
in testing if a value exists in an array.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks for the response, bob.

--


Gary


"Bob Phillips" wrote in message
...
I would guess that Find is aesthetically better, as it is not Excel
dependent, and has more flexibility in the search pattern and then looking
for next. Match scores if you want to do a nearest value find. Horses for
courses I guess. I tend to use Application.Match in responses I give, but
I actually use Find more in my own code.

I have no idea if one is faster ( I would guess Find), never had the need
to time it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
right now i'm using find to search a row of values for an item, if it
find it, i use the rngfound row to enter some data below. if it doesn't
find it, it adds an item to the range.

i could use application.match to return the position, too, so i'm just
wondering if one way is preferred over the other.

--


Gary

match vs find question
 

ok, appreciate the follow up

--


Gary


"Bob Phillips" wrote in message
...
Another point I forgot to mention Gary is that Application.Match is useful in
testing if a value exists in an array.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks for the response, bob.

--


Gary


"Bob Phillips" wrote in message
...
I would guess that Find is aesthetically better, as it is not Excel
dependent, and has more flexibility in the search pattern and then looking
for next. Match scores if you want to do a nearest value find. Horses for
courses I guess. I tend to use Application.Match in responses I give, but I
actually use Find more in my own code.

I have no idea if one is faster ( I would guess Find), never had the need to
time it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
right now i'm using find to search a row of values for an item, if it find
it, i use the rngfound row to enter some data below. if it doesn't find it,
it adds an item to the range.

i could use application.match to return the position, too, so i'm just
wondering if one way is preferred over the other.

--


Gary