ml
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of tangledweb
Sent: Apr/Thu/2012 12:39
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ redim preserve seems to only allow columns
increase which is backwards
I want to use an array
= worksheetfunction.transpose(outputarray)
>
>
>
> If the input and output ranges would be the same size, you could just use
> one array for input and output, and obviously no need for transposing or any
> funny business.
>
>
>
> Asa
>
>
>
> From: excel-macros@googlegro
xcel-macros@googlegroups.com
Subject: $$Excel-Macros$$ redim preserve seems to only allow columns
increase which is backwards
I want to use an array to store values as more efficient that doing it cell
by cell,
then copy the entire array into the sheet range when done. But the size of
the
array
I want to use an array to store values as more efficient that doing it cell
by cell,
then copy the entire array into the sheet range when done. But the size of
the
array not know initially. I do know that number of columns, but not the
number
of rows. So I will have to do some redim preserv
