Just reverse your rows and columns--both when you assign the values and when you
read the values back.

ReDim Preserve arrData (1 to 13, 1 to z)
arrData(1,z) = [cell value]




Dave wrote:

And second, look at ReDim in VBA's help. You'll find that you can only change
the last dimension.

Thanks, Dave. Can you recommend a dynamic way create a N Rows, Y
Columns array where N is uncertain?

--

Dave Peterson