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