Is it possible to Insert Array into Excel Table

[brusk]

I'm running a query from two tables and presenting the cut down version into another. Is it possilbe to take the 2 dimensional array and insert it into an empty table without looping through the array? Or if I have to loop through the array is it possible to insert one of the array "records" into the table or do I have to loop through that dimension of the array also.

Thanks,
Bruce

[Roger Govier]

Hi

Supposing your final array is called ary3, then

Sheets("Sheet1").Range("A1").Resize(UBound(ary3), UBound(ary3, 2)) = ary3

Change location to suit