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.)