excel vba array to range only 69536 rows code example

Example: excerl vba array to range

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

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