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 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]...
> 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,

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" <[email protected]> wrote in message
news:[email protected]...
> 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]...
>> 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
>>
>
>