Range.ListNames Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Pastes a list of all nonhidden names onto the worksheet, beginning with the first cell in the range.

expression .ListNames

expression A variable that represents a Range object.

Return Value

Variant

Use the Names property to return a collection of all the names on a worksheet.

This example pastes a list of defined names into cell A1 on Sheet1. The example pastes both workbook-level names and sheet-level names defined on Sheet1.

Worksheets("Sheet1").Range("A1").ListNames

Concepts

Other resources

Show: