AnsweredAssumed Answered

Help passing array variable to Excel via ActiveX

Question asked by dgoderich on Sep 12, 2013
Latest reply on Oct 9, 2013 by dgoderich
Hi Folks,
I am trying to pass an array variable of 601 points to an Excel sheet via ActiveX/formula object.  I have tried the following code below but what it does is it places the first item of the array in all 601 cells.

The Excel sheet name is "TRACE DATA", the variable which is an array of 601 real numbers is in the array variable TRACEDATA_8563

Here is the code in the formula object:   

ExcelApp.Sheets("TRACE DATA").Range("B1:B601").Value=TRACEDATA_8563;

Any suggestions will be appreciated.