Hello,

I am trying to data from Access into Excel. Since the data set is bigger than one sheet can handle, I decided to go with array. However, I don't know how to break the array into sub set...

So, the question is

I have 100,000 x 10,000 array.
Is there a function to put 50,000 x 10,000 in Sheet 1, then next 50,000 x 10,00 into Sheet 2?

Thanks,
Junho