opposite of nothing

[bobaol]

Hi, the code below tries to find "Account". I know what to do when it is not found. however, please help me figure out how to do this when "Account" is found.

Here is what I want. If "Account" is found, then go to cell a1, if "Account" is not found, then find "Supplier", if "Supplier" is found, go to cell a2, if "Supplier" is not found, go to cell a3. thank you in advance. ****

If Selection.Find(What:="Account", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False) Is Nothing Then

 

[bolo]

you could always use the key word NOT(). ie.

Not(selection.find....is nothing)

hope that helps.