Hi,

I have created a userform add-in for generating dynamic ranges (which works
well) but the created ranges do not appear in the 'Edit > Goto...' list. I
know i could just type them in each time, but is there any way of forcing
the names on to the list so they can be selected?

Thanks people,

Tim

You need to add the ranges into the worksheet Define Name list like using
menu Insert - Names - Define. Use code like this

ActiveWorkbook.Names.Add Name:="Joel", RefersToR1C1:= _
"='Finishes Checklists'!R28C7"

The range of address can be obtained by using ADDRESS

MyAddress = Range("A1:B100).address(ReferenceStyle:=xlR1C1,external:=true)


"Tim" wrote:

> Hi,
>
> I have created a userform add-in for generating dynamic ranges (which works
> well) but the created ranges do not appear in the 'Edit > Goto...' list. I
> know i could just type them in each time, but is there any way of forcing
> the names on to the list so they can be selected?
>
> Thanks people,
>
> Tim
>
>
>

thanks Joel. i'll see if i can include it successfully in the add-in

"Joel" <(E-Mail Removed)> wrote in message
news:F334033D-5008-4516-8E71-(E-Mail Removed)...
> You need to add the ranges into the worksheet Define Name list like using
> menu Insert - Names - Define. Use code like this
>
> ActiveWorkbook.Names.Add Name:="Joel", RefersToR1C1:= _
> "='Finishes Checklists'!R28C7"
>
> The range of address can be obtained by using ADDRESS
>
> MyAddress = Range("A1:B100).address(ReferenceStyle:=xlR1C1,external:=true)
>
>
> "Tim" wrote:
>
>> Hi,
>>
>> I have created a userform add-in for generating dynamic ranges (which
>> works
>> well) but the created ranges do not appear in the 'Edit > Goto...' list.
>> I
>> know i could just type them in each time, but is there any way of forcing
>> the names on to the list so they can be selected?
>>
>> Thanks people,
>>
>> Tim
>>
>>
>>