How to read data from a worksheet into an array in a module?

[Bob Phillips]

Forgive my ignorance but isn't using ReDim expensive in the memory department?

It may well be, but one ReDim isn't going to hurt anyone.

But, as you can see from my post, it was unnecessary, as by loading the array directly the system dimensions the array.