Preserve keyword

[LesHurley]

Can anyone suggest a way to ReDimension the R dimension in
ReDim Preserve a(R,C) ?

 

[Rick Rothstein]

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

 

[LesHurley]

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.

 

[Rick Rothstein]

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).

 

[Kenneth Hobson]

'You can use the worksheet function Transpose() to do it:

'pgc01, http://www.mrexcel.com/forum/showthread.php?p=1790513
Sub TestArray()
Dim v, v1

ReDim v(1 To 3, 1 To 4)

' some code

With Application
v1 = .Transpose(v)
ReDim Preserve v1(1 To 4, 1 To 5)
v = .Transpose(v1)
End With
End Sub

 

[LesHurley]

Thanks everyone. For my present purposes I was able to calculate the
ultimate dimensions of the array before the ReDim and therefor no need for
the Preserve keyword. I'm sending a ParamArray List() to the function and in
this case the size of List() and of each member of it are known when the
function is called. I guess if I ever need more than that I will just write
it in C++.

 

[Dana DeLouis]

You may want to look at the Collection or Dictionary objects.
Depending on what you are doing, they can sometimes simplify complicated
programming.
- - -
Dana DeLouis