Workbook.Names (Excel)

Returns a Names collection that represents all the names in the specified workbook (including all worksheet-specific names).

Using this property without an object qualifier is equivalent to using ActiveWorkbook.Names.

Dim nmsNames As Names
Set nmsNames = ActiveWorkbook.Names