Skip to main content
Version: 20 R7 BETA

VP REMOVE NAME

VP REMOVE NAME ( vpAreaName : Text ; name : Text { ; sheet : Integer } )

ParameterTypeDescription
vpAreaNameText->4D View Pro area form object name
nameText->Name of the named range or named formula to remove
scopeInteger->Target scope (default=current sheet)

Description

The VP REMOVE NAME command removes the named range or named formula passed in the name parameter in the defined scope.

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

Pass the named range or named formula that you want to remove in name.

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

  • vk current sheet
  • vk workbook

Example

$range:=VP Cell("ViewProArea";0;0)
VP ADD RANGE NAME("Total1";$range)

VP REMOVE NAME("ViewProArea";"Total1")
$formula:=VP Get formula by name("ViewProArea";"Total1")
//$formula=null

See also

VP Name