Named data range as source

[wmbb]

I want to insert a chart by macro.
The datarange is named as _datapoints.

how can I use the datarange _datapoints as the source in stead of Source:=Sheets("sheet1").Range("A35:B338")[/color red] in the code below ?

ActiveChart.SetSourceData Source:=Sheets("sheet1").Range("A35:B338"), PlotBy _
        :=xlColumns
    ActiveChart.Location Where:=xlLocationAsObject, name:="Sheet2"

 

[PHV]

Have you tried this ?
Source:=Range("_datapoints")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[wmbb]

Thnx, Source:=Sheets("sheet1").Range("_datapoints") works !