Export (0) Print
Expand All

Range.ListNames Method

Office 2007
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.

Visual Basic for Applications
Worksheets("Sheet1").Range("A1").ListNames



Community Additions

ADD
Show:
© 2014 Microsoft