string search

[anthonycrimin]

I know how to search for a string then select the data below the string header. However if the string does not exist how to a simply jump to the next string search with VBA showing an error because it cannot find the previous string.

many thanks

Anthony

[mangaluli]

I did not understand but maybe you mean this:

if string = "123" then
code code code
end if

if string = "456" then
code code code
end if

Or you can use "Case" (Faster and cleaner)

Select Case string
Case "123"
CODE! HERE!
Case "456"
CODE! HERE!
Case "789"
CODE! HERE!
Case Else
CODE! HERE! ELSE!
End Select