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