Bob Phillips
12/14/2006 6:37:00 PM
Just load it into the range
Range("A1:C3") = ary
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Chris" <Chris@discussions.microsoft.com> wrote in message
news:B0B58924-4844-4709-9C1C-7AB67265A8B4@microsoft.com...
> Hi,
>
> I have a 2 dimensional array.
>
> I would like to load the array into a worksheet starting at lets say: A1.
>
> I know how to do this with a nested looping structure but thought maybe
there
> was a function available in the vb or excel libraries.
>
> I tried using worksheetfuncton.transpose but it does not give the desired
> result.
>
> thanks
>
> Chris