Re: Reading from a excel *** to an array

Not unless you want to have an array of arrays. however, for so small a
range, you shouldn't have much impact.

--
Regards,
Tom Ogilvy



"Pradip Jain" <PradipJain@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:12AA9E3C-0E6B-4657-A33C-2C52763E9069@xxxxxxxxxxxxxxxx
> i am running simulation analysis. Each simulation returns results comes in
> cells b60 to b85 of sheet2. next simulation will also return its output in
> the same range.
>
> suppose i am running 10 simulations. each simulation output is basically a
> 10 rows by 1 column range in sheet2. this results need to go into an array
> called FinalOutput which would be a 26 by 10 array. I want to read the
entire
> range "b60 to b85" in sheet2 into the FinalOutput array. Basically
depending
> on the simulation number, an entire column of FinalOutput array gets
created.
> so simulation 1 output gets transferred to column 1 of final output array
and
> so on. is there some way i can transfer an entire range into a column of
an
> array.
>
> thanks
> pradip
>


.

Loading