VP Find table
History
| Release | Changes |
|---|---|
| 19 R7 | Added |
VP Find table ( rangeObj : Object ) : Text
| Parameter | Type | Description | |
|---|---|---|---|
| rangeObj | Object | -> | Cell range |
| Result | Text | <- | Table name |
Description
The VP Find table command returns the name of the table to which to the rangeObj cell belongs.
In rangeObj, pass a cell range object. If the designated cells do not belong to a table, the command returns an empty string.
If rangeObj is not a cell range or contains multiple ranges, the first cell of the first range is used.
Example
If (FORM Event.code=On After Edit && FORM Event.action="valueChanged")
$tableName:=VP Find table(FORM Event.range)
If ($tableName#"")
ALERT("The "+$tableName+" table has been modified.")
End if
End if