Outputting an array to a surface graph using VBA

[multiplemigs]

In the vba coding im using, I eventually wind up with a 100x100 array.
Is there a way to output this to a surface graph (top down view) from
within VBA itself? or am I forced to display the data in a spreadsheet
in excel and then plot that?

thanks
andrew

 

[Bob Greenblatt]

In the vba coding im using, I eventually wind up with a 100x100 array.
Is there a way to output this to a surface graph (top down view) from
within VBA itself? or am I forced to display the data in a spreadsheet
in excel and then plot that?

thanks
andrew

As far as I know, the data must be in a worksheet in order to be plotted. I
just played around a little with arrays in defined names and could not get
it to work. You could simply move the array to a hidden worksheet and plot
that.