Good day all,
Im new to VBA, and i have a for loop throu an array but i dont know how to put the out on a specific cell instead of the MsgBox. i want my out put of the array to be put on cell E6..can we do this?
Sub Test()
Dim myArray As Variant
Dim x As Integer
Dim cell As Integer
myArray = Array(10,20,30,40,50) 'define array
For x = LBound(myArray) To UBound(myArray) 'define start and end of array
MsgBox (myArray(x))
Next x ' Loop!
End Sub