PDA

View Full Version : Is it possible to Insert Array into Excel Table



brusk
11-14-2014, 07:22 PM
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
11-15-2014, 01:43 AM
Hi

Supposing your final array is called ary3, then

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

Change location to suit