Searching particular string in an excel spreadsheet

What are the options other than 'Range.Find' to search for a string in a spreadsheet? Am using actxserver('Excel.Application'). 'Range.Find' does not help since it start to look from first letter of the string and stops there. For ex. am looking for a string 'Jimmy'. Find would look everything row by row starting with J. if it finds 'John' it shall stop right there. How to make it look for complete string?

Answer 1

[Ghenji]

This worked for me.

Range.Find('String', [], [], 1)

Since the position for LookAt is 4th and I need xlWhole. xlWhole = 1; xlPart = 2;

Referring to this documentation https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-find-method-excel

Answer 2

[Image Analyst]

How about hauling it into MATLAB with xlsread() and search each cell for the string with strfind()?

[Ghenji]

well am loading all the the parameters using excel.application. Going back to xlsread() would be long road and further even after using strfind() i will have to move back to to excel.application since I want read the data labelled with some color.