4D v18VP Name |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v18
VP Name
|
VP Name ( vpAreaName ; rangeName {; scope} ) -> Function result | ||||||||
Parameter | Type | Description | ||||||
vpAreaName | Text |
![]() |
4D View Pro area form object name | |||||
rangeName | Text |
![]() |
Existing range name | |||||
scope | Longint |
![]() |
Range location (current sheet if omitted) | |||||
Function result | Object |
![]() |
Range object of name | |||||
The VP Name command returns a new range object referencing a named range.
In vpAreaName, pass the name of the 4D View Pro area. If you pass a name that does not exist, an error is returned.
The rangeName parameter specifies an existing named cell range.
In the optional scope parameter, you can designate a specific spreadsheet where rangeName is defined. If omitted, the current spreadsheet is used by default. You can explicitly select the current spreadsheet or the entire workbook with the following constants:
Constant | Type | Value | Comment |
vk current sheet | Longint | -1 | Designates current sheet of the 4D View Pro area (default) |
vk workbook | Longint | -2 | Designates the entire workbook of the 4D View Pro area. |
You want to create a range object for the range named "Total":
$name:=VP Name("ViewProArea";"Total")
4D View Pro Range Object Properties
VP ADD RANGE NAME
VP All
VP Cell
VP Cells
VP Column
VP Combine ranges
VP Get names
VP REMOVE NAME
VP Row
Product: 4D
Theme: 4D View Pro Language
Number:
9539
Created: 4D v17 R4
4D View Pro Reference ( 4D v18)