On Friday, April 6, 2012 5:52:18 PM UTC+5:30, merjet wrote:
'i am assigning it this way, but in next iteration
'previous values dissappear
vfile = rng

Yes, because you are replacing, not appending.

I don't know how to append chunks (versus element by element) but guess that it would not reduce run-time anyway.

so i guess there isn't much in VBA to appending chunks of data to an array without the process of looping.....consider the case when the data flows thousands of rows down & many columns across. it would really be a slow process to append such data to an array using a loop. :(