saving in excel cells with activeX

[agyna]

Hello,

I just need a quick help here: I have some data. I am using an excel template to write to it to a specific location (in the column names Marker1 and Marker2 under another name and save it under a another name, so that the template remains unchanged. It seems to work, but my array of data cannot copy everything to excel. Any quick help?

Attached are my codes and the template being used.

Thank you.

[ben64 · Accepted solution]

Two issues in your code,

First: Your column range is C5 to C9, that is 5 values. If your array contain more than 5 data only the first 5 will be written to your Excel sheet. The value of cell2 (currently C9) should be dynamic: C(5 + ArraySize-1).

Second: Excel Ranges are 2D Array, Your 1D array should be converted to 2D and then transposed because you want to fill a column. If you don't transpose the first value of your array will be written in cells C5 to C?

Ben64