Names property

Returns an IXLSNames collection that represents all the defined names in the specified Workbook. Read-only IXLSNames.

Syntax

property Names: IXLSNames;

This example creates a new defined name for the Workbook.

Workbook.Names.Add('MyName','=Sheet1!$A$2');