Thursday, October 17, 2013

List out named ranges with VBA

You may have a list of named ranges in Excel and you want to list down all in a sheet.
Use the below code to get the list of all the available named ranges in the workbook.

Sub ListNames()
Dim wks As Worksheet
Set wks = Worksheets.Add
wks.Range("A1").ListNames
End Sub
Posted by at

1 comment:

  1. My BlogsNovember 6, 2013 at 9:28 AM

    This is another post related to named manager in Excel, how to define a range by a name:

    http://exceltipstechniques.blogspot.in/2013/11/working-with-name-manager-in-excel.html

    ReplyDelete

Subscribe to: Post Comments (Atom)