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