AKK
07-25-2007, 01:02 PM
Part of my macro works down a list of search strings, then does certain things with the string when it finds it.
How can I tell it that if it doesn't find the first string, it should move on to the next one? I think I'm looking for something like
[run search with first search term]
If [search string found] Then
[do stuff with selection]
Else [move down one cell to the next search term]
Loop
...if that makes sense. I'm just not sure about the syntax. Any ideas?
How can I tell it that if it doesn't find the first string, it should move on to the next one? I think I'm looking for something like
[run search with first search term]
If [search string found] Then
[do stuff with selection]
Else [move down one cell to the next search term]
Loop
...if that makes sense. I'm just not sure about the syntax. Any ideas?