How to output an array in vba

Question

I have created an array named "arrRecords" using a query from ODBC. I want to output the value of that array into my worksheet. The array has 4 columns but the number of rows depends on the query. How do i do this?

Please help.

This question already has a (much better) answer here: stackoverflow.com/questions/6063672/… — RBarryYoung
– RBarryYoung, Commented Jun 21, 2017 at 15:20
Possible duplicate of Excel VBA function to print an array to the workbook — RBarryYoung
– RBarryYoung, Commented Jun 21, 2017 at 15:20

Lucas Raphael Pianegonda · Accepted Answer · 2017-06-21 15:17:41Z

0

Something like this should work:

Sub printarray(arrRecords)

Dim i As Long, j As Long

For i = 1 To 4
      For j = 1 To UBound(arrRecords, 2)
            ActiveSheet.Cells(j, i).Value = arrRecords(i, j)
      Next j
Next i

End Sub

Activesheet.cells needs to be replaced with whatever loaction you want to input the array.

Note that depending on your set up the dimensions may be switched. With ubound(array,2) one can get the Upperbound of an array second dimension. Then just loop through it. Note also that i and j do not have to start with 1 this is dependend on your case.

Flies away!

answered Jun 21, 2017 at 15:17

Lucas Raphael Pianegonda

1,18112 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to output an array in vba

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related