Excel Range to Array in VBA

[Geoff]

Is there a way though VBA in one command to put a range to an array.

E.g.

strArray()=ExcelRange.Value

This does not work for us but is it possible without looping through the
range.

Thanks in advance.