Drop down list of range names in editor

[EVisser]

Hi,

Can someone please give me a hint?
I've specified quite some ranges in my worksheet. In my code I want to use the properties of some of those ranges, but is there a way to get a drop down list of the names of the ranges I've specified? Or an auto complete function just as there is for your variables.
Just typing the first part of the name and then Ctrl+Space doesn't show them, neither does Alt+Arrow down or something like that.

Many thanks in advance.

Edward

 

[EVisser]

I'm new to this forum, so just to be sure : do I ask this wrong question? In the wrong forum? Or does no one have the answer?

 

[MickG]

This will give you a list of named ranges and their range addresses

[COLOR="Navy"]Sub[/COLOR] MG18Dec47
Range("A1").ListNames
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[EVisser]

Hi Mick,

Thanks for your reply. As a workaround this is already very useful.
However, I was looking for a way to get a suggestion/auto completion when I'm typing my code.