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