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