Worksheet.Names (Excel)

Returns a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).

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

Dim nmsNames As Names
Set nmsNames = ActiveSheet.Names