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

[Tim]

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

 

[Joel]

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]

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