excel vba range to collection code example Example: Excel vba range to array Dim vArray As Variant vArray = Range("A1:A10").Value2