VP Name

Home

4D v19

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

Description

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.

Example

You want to give a value to the "Total" named range.

  // name the B5 cell as Total

 VP ADD RANGE NAME(VP Cell("ViewProArea";1;4);"Total")

 $name:=VP Name("ViewProArea";" Total")

 VP SET NUM VALUE($name;285;"$#,###.00")