range names

1inus

New Member
Joined
Jul 6, 2006
Messages
40
is it possible to list all range names for a workbook on a worksheet?
thanks
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Hi,

YES it is :)
and it's almost plain english
Code:
Sub list_names()
Range("A1").ListNames
End Sub
TIP: check the helpfiles

kind regards,
Erik
 
Upvote 0
Hi, I would be interested to use that trick, but can't make it to work
hit F3 and then ? what to do ?

best regards,
Erik


Hi erik,


A dialog box should appear if not make sure that your F keys are not lock. You should have a button to the left of the key board that say "F Lock". But again everyone keyboard is different. Here is a link below that gives that example.

http://www.bettersolutions.com/excel/EFC133/VG819416332.htm


Hope that helps.
 
Upvote 0
thank you for explanation
no, it's not the "lock" :) I'm using function keys all the time
when checking the menu there is no "F3" next to insert/name/paste
(like you have "F1" next to Help)
using XP

anyway you learned me something, I checked the link ...
thank you :)
 
Upvote 0
It works in XL2003, there is no shortcut indicator on the menu though, but F3 works.
 
Upvote 0
:unsure: :oops: :unsure:
I do not have a "lock"functionkeys key, it didn't work 30 minutes ago.
Now it is working.

For the life of me, couldn't think what went wrong: probably a finger who didn't hit the right button for 10 times :rolleyes:

thanks !
 
Upvote 0
:unsure: :oops: :unsure:
I do not have a "lock"functionkeys key, it didn't work 30 minutes ago.
Now it is working.

For the life of me, couldn't think what went wrong: probably a finger who didn't hit the right button for 10 times :rolleyes:

thanks !

Maybe you didn't have any names in the workbook. If you don't you just get a beep (Excel 2000).
 
Upvote 0

Forum statistics

Threads
1,214,657
Messages
6,120,773
Members
448,991
Latest member
Hanakoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top