Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
range name does not appear name box?
Hi All,
The code snippet below is how l have added a named range to my workbook. The variables are defined via a form and the range is added to the workbook. The problem is that when l look for the name via the name dropdown arrow it is not there! If l look via Insert, Names, Define l can see it and l can do calculations, lookups etc. Can anybody throw any light on this please, l need the name to appear in the dropdown. ActiveWorkbook.Names.add Name:=RngName, RefersTo:= _ "=OFFSET(" & sht & tlc & ",0,0," & Rfun & "," & Cfun & ")" Regards Michael |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
range name does not appear name box?
Dynamic ranges (ones that use formulas) are volatile, and can not appear in
the drop down box. You need to somehow make it static (constant) if you want it in the dropdown. Note that you can still use it in any formula/reference by just typing the name. Why do you need the name to appear in the dropdown? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "michael.beckinsale" wrote: Hi All, The code snippet below is how l have added a named range to my workbook. The variables are defined via a form and the range is added to the workbook. The problem is that when l look for the name via the name dropdown arrow it is not there! If l look via Insert, Names, Define l can see it and l can do calculations, lookups etc. Can anybody throw any light on this please, l need the name to appear in the dropdown. ActiveWorkbook.Names.add Name:=RngName, RefersTo:= _ "=OFFSET(" & sht & tlc & ",0,0," & Rfun & "," & Cfun & ")" Regards Michael |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
range name does not appear name box?
Dynamic ranges (ones that use formulas) are volatile, and can not appear in
the drop down box. You need to somehow make it static (constant) if you want it in the dropdown. Note that you can still use it in any formula/reference by just typing the name. Why do you need the name to appear in the dropdown? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "michael.beckinsale" wrote: Hi All, The code snippet below is how l have added a named range to my workbook. The variables are defined via a form and the range is added to the workbook. The problem is that when l look for the name via the name dropdown arrow it is not there! If l look via Insert, Names, Define l can see it and l can do calculations, lookups etc. Can anybody throw any light on this please, l need the name to appear in the dropdown. ActiveWorkbook.Names.add Name:=RngName, RefersTo:= _ "=OFFSET(" & sht & tlc & ",0,0," & Rfun & "," & Cfun & ")" Regards Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |