Range name table

B

Bill Ridgeway

I want a list of all the defined names and their cell references. This used
to be done in Lotus by Range/Name/Table. I can't find the equivalent in
Excel. Can it be done.

Thanks.

Bill Ridgeway
Computer Solutions
 
W

willwonka

Find a spot and:

Insert...Name..Paste... and click on Paste List at bottom left.

This should work for you.
 
B

Bill Ridgeway

Thanks for that. I was looking (nearly) everywhere for that but didn't think
of looking at Insert Name when I didn't actually want to insert anything!!
Thinking logically can be very useful but it can be very frustrating when MS
is illogical.

Regards.

Bill Ridgeway
Computer Solutions
 
B

Bob Phillips

Get of Jan-Karel Pieterse's NameManager utility, it does that and a whole
lot more Jan Karel Pieterse has a utility designed to improve working with
defined names.

It is a free add-in, and you can get it at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

Here's a simple function to do it

Function ListNames()
Dim nem As Name
For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name & ", " & nme.RefersTo
Next nme
End Function


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top