Adding 'dynamic range names' to the 'Edit Goto...' pane
 

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

Adding 'dynamic range names' to the 'Edit Goto...' pane
 

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,ext ernal:=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

Adding 'dynamic range names' to the 'Edit Goto...' pane
 

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

"Joel" wrote in message
...
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,ext ernal:=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