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