Showing posts with label copy range. Show all posts
Showing posts with label copy range. 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