Returns DefinedName object for the cell or nil if there was no name defined for the cell.
DefinedName(Parameters
- sheet
- The worksheet which the cell lives on. (This is needed to get access to, the Defined names which Excel actually stores on Workbook)
Returns
- DefinedName
- DefinedName object or nil if none was defined.
Remarks
Note that name is only defined for the given cell if the definition is exactly the cell and not just that the cell is part of the range definition.
If wanting to know if the cell is part of a defined name range definition then go through the DefinedNames array in the workbook object.