Creating plots in VBA

[dougjones]

In my code, I'm creating a surface chart and use the statement "ActiveChart.SetSourceData:=Sheets(namSheet).Range(namRange). I've assigned the values for namesheet and namrange elsewhere in the program, where namrange is an array e.g. "B21:T64". I want to replace Range(namrange) with a range called MyRange which I also create elsewhere with Set MyRange=Range(ActiveCell,ActiveCell.offset(20,30)). I get the error msg "Object doesn't support this property or method." How can I define MyRange so that it can replace Range(namrange) in the SetSourceData statement? The plot is created even though the programs stops on the setSourceData line.