Hi everyone,
I have created an array in VBA which I want to put back into excel at the end of my programme. The Array will be a 20 by 6 array, and filled with numbers.
However, in columns A and B (say starting in row 1), I want to put in columns 1 and 4 from my array.
I;m thinking there must be an easy way of doing this, rather than creating 3 new 20X2 arrays and then dumping each one in excel using smthg like:
[a1].Resize(endrow, 2).Value = Arr1
this beginner would appreciate any help!
I have created an array in VBA which I want to put back into excel at the end of my programme. The Array will be a 20 by 6 array, and filled with numbers.
However, in columns A and B (say starting in row 1), I want to put in columns 1 and 4 from my array.
I;m thinking there must be an easy way of doing this, rather than creating 3 new 20X2 arrays and then dumping each one in excel using smthg like:
[a1].Resize(endrow, 2).Value = Arr1
this beginner would appreciate any help!