checking for string
How do I check for a specific string strored in an excel sheet where the position of the string is not fixed? I have tried checkpoint datasase or string but it does not help as database text checks for string from left to right and when an exact match field is enabled, the result will always be fail as all the string before it will be capture as well.
Re: checking for string
Try this one:
Set objExcel = createobject("Excel.application")
set rng = objexcel.Range("A1:H100")
set rngFound = rng.Find("s")
If rngFound is nothing Then