Skip to main content
Version: Next

VP Name

VP Name ( vpAreaName : Text ; rangeName : Text { ; sheet : Integer } ) : Object

ParameterTypeDescription
vpAreaNameText->4D View Pro area form object name
rangeNameText->Existing range name
sheetInteger->Range location (current sheet if omitted)
ResultObject<-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 sheet 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:

  • vk current sheet
  • vk workbook

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")

See also

VP ADD RANGE NAME
VP ALL
VP Cell
VP Cells
VP Column
VP Combine ranges
VP Get names
VP REMOVE NAME
VP Row