Returns a Names collection that represents all the defined names in the specified Worksheet. Read-only
IXLSNames Interface.
Syntax
Example
This example creates a new defined name for the Worksheet one, which refers to Sheet3!A2 cell.
Workbook.Worksheets[1].Names.Add('MyName','=Sheet3!$A$2');