FindCell Function (Table)

Class

Table.

Action

Returns a cell containing specified text.

Availability

This functionality is supported only if you are using the Classic Agent.

Syntax

Cell = table.FindCell(sText)
Variable Description
Cell The cell containing sText. TABLECELL.
sText The text in a cell in the table. STRING.

Notes

FindCell searches cells for sText starting in row 1, column 1. 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. For example, a cell with contents "First Quarter" will match the search text "First Q*".

If sText is not found, FindCell raises the exception E_ITEM_NOT_FOUND.

Example

TABLECELL tcCell
tcCell = EmpForm.EmpTable.FindCell("Homer")
EmpForm.EmpTable.ClickCell(tcCell)