Hello,

I am trying to learn some things about arrays. Can someone help me to make an understandable simple VBAcode. In column B I have some names, and in colum A I see the number of times these names have to be copied.
In Range A2:F4 you 'll see the output as it should be. I found below mentioned VBA on internet, but I don't see how I can adapt this VBA to my situation.

Sub From_sheet_make_array()
      Dim MyArray As Variant
      MyArray = Range("B2:B5").Value

      'Looping structure to look at array.
      For i = 1 To UBound(MyArray)
        MsgBox MyArray(i, 1)
      Next
End Sub
FillingArraysViaVBA.xlsb

Thanks for your help/Excelbat