Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range Names / Charting | Excel Discussion (Misc queries) | |||
Dynamic Range Names? | Excel Worksheet Functions | |||
dynamic range names in Edit - Go to | Excel Programming | |||
Dynamic Range Names For a Graph | Charts and Charting in Excel | |||
formula to set up dynamic range in names | Excel Worksheet Functions |