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

  • Thread starter Thread starter Tim
  • Start date Start date
T

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top