VP REMOVE NAME

Home

4D v18

VP REMOVE NAME


VP REMOVE NAME ( vpAreaName ; name {; scope} )

Parameter	Type	Description
vpAreaName	Text	4D View Pro area form object name
name	Text	Name of the named range or named formula to remove
scope	Number	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:

Constant	Value	Comment
vk current sheet	-1	Designates current sheet of the 4D View Pro area (default)
vk workbook	-2	Designates the entire workbook of the 4D View Pro area.

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