Range.ListNames (Excel)
Pastes a list of all nonhidden names onto the worksheet, beginning with the first cell in the range.
Use the Names property to return a collection of all the names on a worksheet.
ActiveCell.ListNames
Pastes a list of all nonhidden names onto the worksheet, beginning with the first cell in the range.
Use the Names property to return a collection of all the names on a worksheet.
ActiveCell.ListNames