Populate array to range of cells

do you want the result to be one column with all the values from the source sheet?
If you wnt the columns same like on the source sheet just next to each other starting at A1 would it not be easier to copy them over?

I this particular case

Please Login or Register  to view this content.

Originally Posted by skywriter

I already beat you to this.
Check out this thread where I had the same question.

If you look at the array you've created you will see that it only contains the first range.

Hi there,

I just realized that I actually saw that thread when I googled.
However, I still dont understand.

Does it mean that I will need to do something like:

HTML Code: 

to make arrCopy becomes a range object?
If yes, I tried, but I still can't get it though....

Can assist to further guide me?

Thank you!

Originally Posted by jindon

I this particular case

Please Login or Register  to view this content.

Hi Jindon,

Thank you for the reply.

I tried adding the code given by you and I got run-time error '13' type mismatch for the last line.
Should I dim x?

I tried though... but couldn't work.
Maybe I missed out some other thing. Could you further point out for me?

Thank you.

OOps, should be

Please Login or Register  to view this content.

[QUOTE=jindon;4199435]OOps, should be

Hi jindon-san,

Thank you very much for your reply.
Your code worked.

I made some changes:

Please Login or Register  to view this content.

If I understand correctly, you are using the index function which is similar to the index formula, 'evaluate' will be populating the data to the next row? and of course the last argument is the numbering of the columns.

And then resize it? UBound(arrCopy, 1) is first dimension and UBound(arrCopy, 2) is the second dimension. correct?

Thank you!

1)
When you need to extract multiple rows/columns from Array, it should be 2d array for 2nd arg and 1d array for 3rd arg.
Evaluate method will create 2d array from 1 to the last row in this case.
i.e
1,1
2,1
3,1
4,1
.
.
.

2)
For dumping the data from array, you will need to specify the size of cells(range) identical to the size of the Array.
You will need to understand Resize property when dealing with VAB Arrays.

Originally Posted by jindon

1)
When you need to extract multiple rows/columns from Array, it should be 2d array for 2nd arg and 1d array for 3rd arg.
Evaluate method will create 2d array from 1 to the last row in this case.
i.e
1,1
2,1
3,1
4,1
.
.
.

2)
For dumping the data from array, you will need to specify the size of cells(range) identical to the size of the Array.
You will need to understand Resize property when dealing with VAB Arrays.

Got it!
Thank you very much!