Hi,
I've been trying to use the Excel VBA WorksheetFunction.Find or .Search functions in order to find if the text in a cell starts with the word Cust.
The problem I have is that when it finds the word it returns 1, but when it doesn't it gives the error "1004" - Unable to find the search property of the worksheetfunction class.
I used it as follows:
CellVal = Cells(i, 1)
rowCount = Application.WorksheetFunction.Search("Cust", CellVal)
What is wrong?
Thank you!