extract 2 dimensional arrays from a sheet to another

[aleenkhan]

Hi,

Can someone help me in finding the way to extract a 2 dimensional array from a worksheet/workbook to another worksheet/workbook?

I am trying to extract a range of values by declaring array and then reading cell values and pasting it in another file but I am finding it difficult.

Thanks.

 

[Norie]

Is the range you want to extract contiguous?

 

[aleenkhan]

It is non-contiguous range and I want to read the required cells through dynamic arrays as it is faster way to get it done.

Can you please help me for it?

Thanks