Skip to main content
Version: 20 R6 BETA

VP Find table

History
ReleaseChanges
19 R7Added

VP Find table ( rangeObj : Object ) : Text

ParameterTypeDescription
rangeObjObject->Cell range
ResultText<-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

See also

VP Get table range