Assign a range directly to an arry in Excel

[oswaler]

I'm trying to do something that seems simple, but is throwing an error. I have a range with a definite number of values and I'm trying to stick those values in an array without having to iterate through each cell. The code is:

Dim Zip(43191)

Zip = Range("a2:a43192").Value

I get an error saying Cannot Assign to Array. I know all the values are there in that particular range of cells. This worked in past versions. I thought I heard that VBA changed the array assignment methods, so am I maybe doing it wrong now?

Thanks - E