dynamic range names in Edit -> Go to

[Tim Marsh]

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

 

[Gert-Jan]

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
news:[email protected]...

 

[Tim Marsh]

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)