VP Find table
Historique
| Release | Modifications |
|---|---|
| 19 R7 | Ajout |
VP Find table ( rangeObj : Object ) : Text
| Paramètres | Type | Description | ||
|---|---|---|---|---|
| rangeObj | Object | -> | Plage de cellule | |
| Résultat | Text | <- | Nom de table |
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. Si les cellules désignées n'appartiennent pas à une table, la commande retourne une chaîne vide.
If rangeObj is not a cell range or contains multiple ranges, the first cell of the first range is used.
Exemple
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