output 2d array in vba

[MetLife]

Hi,

I have an array that is xx(1 to 121, 1 to 121) as double

and I want to paste the array to the worksheet.

So I did...


Range("DM2:IC123").Value = xx

But what if the size of xx changes? Is there a way to automate the output maybe using the ubound? I'm thinking I would have to set a variable

t = ubound(xx)
range("DM2:IC"&&t).value = xx?

or something like that.

Thanks

 

[Fluff]

Try

Range("DM2").Resize(UBound(xx, 1), UBound(xx, 2)).Value = xx

 

[MetLife]

Thanks, you solution is very simple

 

[Fluff]

You're welcome