Names property

Yields 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');