Splitting an Array

[SonicBoomBand]

I have a huge array that I want to split without looping through it.

The big array is two dimensioned and holds, for example, 3000 rows and 365 columns. I want in my new smaller array the first 200 rows and columns 184 to 365 from the big array. Is there any way to instantly pull this data from one array and put it into my new array?

If not, don't worry, I will just loop through.

Cheers


Andrew Chamberlain
National Grid Transco

 

[gmmastros]

Look in to the Split function.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Zathras]

It is possible to move data to and from a worksheet using variants. But in your case you have more than 256 columns. I think you are stuck with using a loop to move individual elements.

It is also possible to ReDim an array, but since you want the last columns and not the first, that can't help you either.