Preserve keyword
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
|