Application.Names (Excel)
Returns a Names collection that represents all the names in the active workbook.
Using this property without an object qualifier is equivalent to using ActiveWorkbook.Names.
Dim nmsNames As Names
Set nmsNames = Names
Returns a Names collection that represents all the names in the active workbook.
Using this property without an object qualifier is equivalent to using ActiveWorkbook.Names.
Dim nmsNames As Names
Set nmsNames = Names