how to arrange dimensions of source data array?

[MCM]

Hi guys

I am trying to plot a 3D surface graph. but as the user defined
variables are changed (for example number of elements used for
solution) dimensions of graph is also changing. so what can i do in
order to manipulate the source data array for automatic arrangement of
graph ?

here i tried something but it is not working

Worksheets("Sheet1").ChartObjects(2).Chart.SetSourceData
Source:=Sheets(3).Range(Cells(1, 1), Cells(10, 10))


range is only accepting

range("A1:C10")

type format for this process but this not appropriate
for example I can not write An:Cm for user defined n,m numbers
ie how can I use this format in order to arrange automatically source
data array ? ie I want the program arrange the array size automatically
so that a true graph can be obtained for all cases.

please help!

 

[Tom Ogilvy]

Source:=Sheets(3).Range(Sheetts(3).Cells(1, 1), sheets(3).Cells(10, 10))

would be the first thing I would try.

 

[MCM]

thank you very much

it worked!

Source:=Sheets(3).Range(Sheetts(3).Cells(1, 1), sheets(3).Cells(10, 10))

would be the first thing I would try.