create list of named ranges with extra column to contain worksheet name

[Bonnister]

Hello all

I use the ListNames method absolutely fine to create my list of named ranges in my workbooks. So far so good but what would I do to add a third column to my named range table that simply contains the name of the worksheet each named range is located on please?

Any and all help gratefully received as ever

Kenny

[Leith Ross]

Hello Kenny,

Use the Parent property of the Range to return the Worksheet it belongs to. To get the worksheet name use Parent.Name. E.g., MyRange.Parent.Name