Preserve keyword
 

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

Preserve keyword
 

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

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

Preserve keyword
 

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

Preserve keyword
 

'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

Preserve keyword
 

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++.
--
Thanks for your help


"Kenneth Hobson" wrote:

'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

Preserve keyword
 

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


LesHurley wrote:
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++.