Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range not appearing in names drop down
Hi All,
Sorry if posted to 2 newsgroups - my mistake. The code snippet below has been used to add a named range and this appears via Insert, Define, Names and can be used for calculations etc. The problem is if l use the drop down name box it is not there! can anybodt throw some light on this please. I 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.programming
|
|||
|
|||
Named Range not appearing in names drop down
Dynamic range names do appear in the dropown. The reason is presumably
because selecting an item from that list goes to that range, and it is not determined at that point where the range points to, that info is updated when the range name is created/updated, so it doesn't know where a dynamic range name points at. -- __________________________________ HTH Bob "michael.beckinsale" wrote in message ... Hi All, Sorry if posted to 2 newsgroups - my mistake. The code snippet below has been used to add a named range and this appears via Insert, Define, Names and can be used for calculations etc. The problem is if l use the drop down name box it is not there! can anybodt throw some light on this please. I 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.programming
|
|||
|
|||
Named Range not appearing in names drop down
Have you assigned a name to the variable RngName ?
Also does the RefersTo resolve to a valid range? -- Regards, Nigel "michael.beckinsale" wrote in message ... Hi All, Sorry if posted to 2 newsgroups - my mistake. The code snippet below has been used to add a named range and this appears via Insert, Define, Names and can be used for calculations etc. The problem is if l use the drop down name box it is not there! can anybodt throw some light on this please. I need the name to appear in the dropdown ActiveWorkbook.Names.add Name:=RngName, RefersTo:= _ "=OFFSET(" & sht & tlc & ",0,0," & Rfun & "," & Cfun & ")" Regards Michael |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range not appearing in names drop down
Hi Bob,
Thanks for respondind so quickly, l think you had a typo, did you mean dynamic ranges DO NOT appear in the dropdown? Regards Michael |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range not appearing in names drop down
your Name refers to a formula rather than just a Range reference, and Named
Formulae do not appear in the Names Box dropdown. (they do appear when using Name Manager - http://www.decisionmodels.com/downloads.htm ) Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com "michael.beckinsale" wrote in message ... Hi Bob, Thanks for respondind so quickly, l think you had a typo, did you mean dynamic ranges DO NOT appear in the dropdown? Regards Michael |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range not appearing in names drop down
Indeed it was, indeed I did.
-- __________________________________ HTH Bob "michael.beckinsale" wrote in message ... Hi Bob, Thanks for respondind so quickly, l think you had a typo, did you mean dynamic ranges DO NOT appear in the dropdown? Regards Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create named ranges WITHOUT using the Names Cells or Range | Excel Programming | |||
Range Names Appearing Like "Watermarks" | Excel Discussion (Misc queries) | |||
Named Range: Same Names, Multiple Workbooks with Same Sheet Name | Excel Discussion (Misc queries) | |||
VBA defined named range not appearing in Names list... | Excel Programming | |||
Variable names for named range | Excel Discussion (Misc queries) |