Export (0) Print
Expand All
Expand Minimize

Range.ListNames Method 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Dim returnValue As Object
Dim range1 As Range
returnValue = range1.ListNames()

object ListNames();
public System.Object ListNames();
function ListNames() : Object;

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

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2014 Microsoft