Oh, thanks for the information. For GetRows , I assume ar is multiple dimensional array. Since I need further process the data, how can I refer to specific fields (Field1, Field2, Field3) within the array?
Let us say, I want to break it down to 3 small arrays for each field: ar1, ar2, ar3 . That being said ar(0) = ar1(0)+ ar2(0) + ar3(0); ar(1) = ar1(1)+ ar2(1) + ar3(1); .....
How to print array into sheet? For example, how to copy/paste ar to sheets("Test").Cells(1,1)?
Thanks.
Bookmarks