Returns the cell containing the specified text.
FindCell searches cells for text starting in the 1st row, 1st column. It searches each cell in the first row, then searches the second row, and so on, until it finds a match or it reaches the end of the table. You can use wildcards in your search text.
liResult = table.FindCell(text)
| Variable | Description |
|---|---|
| liResult | A list containing the row and column index of the cell (in this order). If the cell is not found the list is empty . LIST OF INTEGER. |
| text | The text in a cell in the table. STRING. |
LIST OF INTEGER liFindCell = Table.FindCell("SilkTest")