vba range to array 1d code example

Example 1: Excel vba range to array

Dim vArray As Variant
vArray = Range("A1:A10").Value2

Example 2: excerl vba array to range

arrayData = Array("A", "B", "C", "D", "E")

[a1].Resize(UBound(arrayData)) = Application.Transpose(arrayData)