Solved
Use FindCell to Find a Word
Hello everyone, I'm currently in the middle of setting up a test to click through a table, but the things I click on are not static so I'm using FindCell to find the thing I am looking for then return the cell to click on. Everything is seems to work if I type in the exact cell data but my problem is that the name comes with a number such as "1-Thing" if it is the first object or "2-Thing" if it is the second. I was wondering if there was a way to make the search succeed if it finds "Thing". Because so far it looks for exact matches. Thank you
Gotcha. :) That method supports the use of wildcards in the caption parameter. So, if you want to find the row that contains the value 'Thing' in column zero, do the following:
myTable.FindRow(0, '*-Thing');
