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)
Syntax
'Declaration
Function ListNames As Object
'Usage
Dim instance As Range
Dim returnValue As Object
returnValue = instance.ListNames()
Object ListNames()
Return Value
Type: System.Object
Remarks
Use the Names property to return a collection of all the names on a worksheet.