dynamic range names in Edit - Go to
 

Hi,

I'm an avid creator / user of dynamic range names, but when i create/define
them, they do not appear in the list of named ranges when I choose
'Edit' - 'Go To' from the menu bar. Is there any way i can force them on
to that list? i have created a userform that i use to easily create my
dynamic ranges, so it would not be a problem to include extra vba to put
them into the 'Go To' list, if i only knew how!

any advice greatfully received!

tim

dynamic range names in Edit - Go to
 

Dynamic ranges are not shown if the range name is invalid. You can test the
names with a small formula (index for example) if the dynamic range is
valid.

=index(yourrange;2) If the name is not valid there will be: #NAME? as a
result.

Succes!

"Tim Marsh" <tmarsh-trousers-@-take off my trousers to
reply-blueyonder.co.uk schreef in bericht
...
Hi,

I'm an avid creator / user of dynamic range names, but when i
create/define them, they do not appear in the list of named ranges when I
choose 'Edit' - 'Go To' from the menu bar. Is there any way i can force
them on to that list? i have created a userform that i use to easily
create my dynamic ranges, so it would not be a problem to include extra
vba to put them into the 'Go To' list, if i only knew how!

any advice greatfully received!

tim

dynamic range names in Edit - Go to
 

Gert-Jan,

thank you, but the range names ARE valid. I can go to them if i type them in
to the Go To box, but my problem is that they do not populate the listbox
automatically (where as other named ranges do populate it)


"Gert-Jan" wrote in message
...
Dynamic ranges are not shown if the range name is invalid. You can test
the names with a small formula (index for example) if the dynamic range is
valid.

=index(yourrange;2) If the name is not valid there will be: #NAME? as a
result.

Succes!

"Tim Marsh" <tmarsh-trousers-@-take off my trousers to
reply-blueyonder.co.uk schreef in bericht
...
Hi,

I'm an avid creator / user of dynamic range names, but when i
create/define them, they do not appear in the list of named ranges when I
choose 'Edit' - 'Go To' from the menu bar. Is there any way i can force
them on to that list? i have created a userform that i use to easily
create my dynamic ranges, so it would not be a problem to include extra
vba to put them into the 'Go To' list, if i only knew how!

any advice greatfully received!

tim