GrOrH
12/14/2006 6:40:00 PM
Range("A1").Resize(UBound(arr) - LBound(arr) + 1, _
UBound(arr, 2) - LBound(arr, 2) + 1).Value = arr
Alan Beban
Chris wrote:
> 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