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

 

[Joe4]

This looks like an Excel question, and it looks like you already posted it on that site:

http://www.mrexcel.com/board2/viewtopic.php?t=83060