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