DeleteNamesInCells

Deletes any names in the current workbook that coincide with any of the values in the specified range.

Applies to

IOAKAddIn, IOAKAPI

SYNTAX

expression1.DeleteNamesInCells

expression2.DeleteNamesInCells(Range)

expression1   Required.  An expression that returns an IOAKAddIn object.

expression2   Required.  An expression that returns an IOAKAPI object.

Range           Required Range.  The range containing the names to be deleted.

Remarks

When applied to an IOAKAddIn object, the DeleteNamesInCells method acts on the current selection in the same way as the OAK | Names | Delete Names in Cells command does. An exception may be raised if the selection is not suitable for the action.

When applied to an IOAKAPI object, the DeleteNamesInCells method applies the specified names over the range indicated by the parameter submitted to the method.

The DeleteNamesInCells method is included for completeness.  It would be unusual to use it from a VBA program.  Its usual use is from the user interface, immediately after an unintended or incorrect use of Excel's Apply names command, to remove the potentially large number of unwanted names thereby produced.

Example

To delete those names in the active workbook that coincide with any values in column Z:

Dim o As Operis_OAK.IOAKAddIn
Dim r as range

Set o = CreateObject("Operis.OAK.Connect")
Set o.ExcelApplication = Application
 
set r=Range("Z:Z")
o.DeleteNamesInCells r