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
Sub copyRange2Array()
myArray = ThisWorkbook.Sheets(1).Range("A1:A4").Value
For i = 1 To UBound(myArray)
MsgBox myArray(i, 1)
Next
End Sub
No comments:
Post a Comment