Showing posts with label array in vba. Show all posts
Showing posts with label array in vba. Show all posts

Wednesday, August 31, 2016

Copy Range to Array

Dim myArray()
Sub copyRange2Array()
myArray = ThisWorkbook.Sheets(1).Range("A1:A4").Value
For i = 1 To UBound(myArray)
    MsgBox myArray(i, 1)
Next
End Sub