PDA

View Full Version : If your search string isn't found...



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?

Bob Phillips
07-25-2007, 01:24 PM
Look at Find in VBA help, there is a good example there.