xSearchFor = "My Text" && can be any Excel data type oFoundRange = oRange.Find(xSearchFor)Find returns the range object that represents the first cell where the information is found. It returns nothing if no match is found. So oFoundRange will have the first match (if there is one) or will be null (if not).
oRange = oExcel.ActiveSheet.Range("A1:A25")>>Then you'll use the Find method:
xSearchFor = "My Text" && can be any Excel data type >>oRange.Find(xSearchFor)>>See the Help file for more parameters that help you fine-tune Find (can search the forumlas, values, or comments; search forward or backward; match case; etc.)