Skip to main content
Version: 20 R6 BETA

VP Get names

VP Get names ( vpAreaName : Text { ; scope : Number } ) : Collection

ParameterTypeDescription
vpAreaNameText->4D View Pro area form object name
scopeNumber->Target scope (default= current sheet)
ResultCollection<-Existing names in the defined scope

Description

The VP Get names command returns a collection of all defined "names" in the current sheet or in the scope designated by the scope parameter.

In vpAreaName, pass the name of the 4D View Pro area. If you pass a name that does not exist, an error is returned.

You can define where to get the names in scope using either the sheet index (counting begins at 0) or the following constants:

  • vk current sheet
  • vk workbook
Returned collection

The returned collection contains one object per name. The following object properties can be returned:

PropertyTypeDescription
result[ ].nameTextcell or range name
result[ ].formulaTextformula
result[ ].commentTextComment associated to the name

Available properties depend on the type of the named element (named cell, named range, or named formula).

Example

var $list : Collection


$list:=VP Get names("ViewProArea";2) //names in 3rd sheet

See also

VP ADD FORMULA NAME
VP ADD RANGE NAME
VP Get formula by name
VP Name