Named Range not appearing in names drop down

  • Thread starter michael.beckinsale
  • Start date
M

michael.beckinsale

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
 
B

Bob Phillips

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.
 
N

Nigel

Have you assigned a name to the variable RngName ?

Also does the RefersTo resolve to a valid range?
 
M

michael.beckinsale

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
 

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

Top