array in VBA

[VCN]

hi, I want to create an array which has 110 elements that have the valu
from colum E ( from E1-E110) of the workbook , How can I do it ?
Thanks in advanc

 

[Tom Ogilvy]

Dim vArr as Variant
vArr = Range("E1:E110").Value

this produces a 2D array

for i = 1 to 110
temp = vArr(i,1)
Next