Find value in list

[coop123]

Hello

I want a macro to find a value in a list then carryout further steps.

If value is found proceed to step 1.
If value is not found proceed to step 2.

So far I have no problem if value is found, but if value is not found as expected I get run-time error 91, at this point I want to proceed to step 2. Can someone suggest code to ignor error and proceed to step 2.

I have tried many sites without any success.

Thank you in advance

coop123

 

[Tim_Excel_]

Something along the lines of

SearchString = "text to search for in range"

Set FindValue = Workbooks("NAME").Worksheets(1).Range("A1:A100").Find(SearchString)
If not FindValue Is Nothing Then
    'Step 1
Else
    'Step 2
End if

 

[coop123]

Thank you that has solved my problem perfectly. Very much appreciated.

coop123

 

[Tim_Excel_]

Glad to have helped