L
LesHurley
Can anyone suggest a way to ReDimension the R dimension in
ReDim Preserve a(R,C) ?
ReDim Preserve a(R,C) ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
You can't. If C is fixed in size, then just swap the dimensions.
L
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.
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.
R
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).
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).
K
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
'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
L
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++.
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++.
D
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
Depending on what you are doing, they can sometimes simplify complicated
programming.
- - -
Dana DeLouis