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

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