Find in a loop
 

I have a loop that is looking for "TA". However, when it finds TA in TAT...
i do not want it to do events on that row as if it was a "TA". The following
two lines are code I have tried to skip over "TAT" values in my search. Any
ideas on how to skip TAT values in my find loop?

If rngFound.Left = 3 = "TAT" Then rngToSearch.FindNext

If rngFound.Left = 3 = "TAT" Then GoTo FindNext

Find in a loop
 

set the proper arguments to FIND so it doesn't match TAT:

LookIn:=xlValues, LookAt:=xlWhole


Lookin:=xlValues
says to look at what the formula produces and not at the formula itself.

Lookat:=xlWhole means the match must be to the whole value of the cell.
then TA < match TAT

Lookin is provided for information. Lookat is critical to your question.
--
Regards,
Tom Ogilvy

"John" wrote in message
...
I have a loop that is looking for "TA". However, when it finds TA in
TAT...
i do not want it to do events on that row as if it was a "TA". The
following
two lines are code I have tried to skip over "TAT" values in my search.
Any
ideas on how to skip TAT values in my find loop?

If rngFound.Left = 3 = "TAT" Then rngToSearch.FindNext

If rngFound.Left = 3 = "TAT" Then GoTo FindNext

Find in a loop
 

ahh yes, thanks... I just was looking at that.

"Tom Ogilvy" wrote:

set the proper arguments to FIND so it doesn't match TAT:

LookIn:=xlValues, LookAt:=xlWhole


Lookin:=xlValues
says to look at what the formula produces and not at the formula itself.

Lookat:=xlWhole means the match must be to the whole value of the cell.
then TA < match TAT

Lookin is provided for information. Lookat is critical to your question.
--
Regards,
Tom Ogilvy

"John" wrote in message
...
I have a loop that is looking for "TA". However, when it finds TA in
TAT...
i do not want it to do events on that row as if it was a "TA". The
following
two lines are code I have tried to skip over "TAT" values in my search.
Any
ideas on how to skip TAT values in my find loop?

If rngFound.Left = 3 = "TAT" Then rngToSearch.FindNext

If rngFound.Left = 3 = "TAT" Then GoTo FindNext