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
End Sub

1 comment:

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