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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

On your keyboard hit the:

F3 key

and click past list
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
 

vane0326

Well-known Member
Joined
Aug 29, 2004
Messages
819
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.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

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 :)
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
It works in XL2003, there is no shortcut indicator on the menu though, but F3 works.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
: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 !
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
: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).
 

Forum statistics

Threads
1,137,335
Messages
5,680,887
Members
419,937
Latest member
Talic

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
Top