Perhaps if you give us a little more information about what you have and
what your are trying to do with it, and show us the code you have so far,
maybe someone here can give you some suggestions as to how to proceed. My
answer to your original question still stands... you can only change the
last dimension of an array when using the Preserve keyword... that is a
fixed limitation for dynamic arrays (it has to do with how the array is
stored in memory).

--
Rick (MVP - Excel)


"LesHurley" wrote in message
...
Rick; Unfortunately, I can't figure out how to make that work. I want to
add
rows to an array with the new rows on the bottom. A worksheet function
Transpose wont because the last column entered woud become the first row.
--
Thanks for your help


"Rick Rothstein" wrote:

You can't. If C is fixed in size, then just swap the dimensions.

--
Rick (MVP - Excel)


"LesHurley" wrote in message
...
Can anyone suggest a way to ReDimension the R dimension in
ReDim Preserve a(R,C) ?
--
Thanks for your help