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