Reading from a excel *** to an array
- From: "Pradip Jain" <PradipJain@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 18 May 2005 04:38:04 -0700
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
.
- Follow-Ups:
- Re: Reading from a excel *** to an array
- From: Alan Beban
- Re: Reading from a excel *** to an array
- From: Alan Beban
- Re: Reading from a excel *** to an array
- From: Tom Ogilvy
- Re: Reading from a excel *** to an array
- From: Mangesh
- Re: Reading from a excel *** to an array
- Prev by Date: Re: Run a batch file from Excel
- Next by Date: Re: need some help
- Previous by thread: Blue Screen of Death Using Dialog Boxes
- Next by thread: Re: Reading from a excel *** to an array
- Index(es):