Thread: Find in a loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default 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