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
|