Matching Partial string in excel Macro
===

Hi I am trying to match the test case name in Column with the site section names in another work book.
I am stuck at apoint where I need to match the test name with site section,
For example:
site section = Appliance 
Test case name = Verify_Right Rail is present in Appliance PLP
I would like to have all the test cases that have word Appliance in that.
I am using following code for this but no use.
 
 Set C = WSRun.Range("B2:B" & RunLR).Find(GTRArray(A, 1), LookIn:=xlValues, lookat:=xlPart)
any help is really apreciated