If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

ResizeArray myArray, N, Y

Alan Beban

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?