Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
48 lines (27 sloc) 965 Bytes
title keywords f1_keywords ms.prod api_name ms.assetid ms.date localization_priority
Range.ListNames method (Excel)
vbaxl10.chm144155
vbaxl10.chm144155
excel
Excel.Range.ListNames
0523f9b3-d422-76b6-889c-75619cb5b9a6
05/11/2019
Normal

Range.ListNames method (Excel)

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

Syntax

expression.ListNames

expression A variable that represents a Range object.

Return value

Variant

Remarks

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

Example

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

[!includeSupport and feedback]

You can’t perform that action at this time.