bobaol
Board Regular
- Joined
- Jun 3, 2002
- Messages
- 225
- Office Version
- 365
- 2003 or older
- Platform
- Windows
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
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