How do I resize a named array in Excel from a MxN array to a mxn .

[Guest]

How do I resize a named array in Excel from a M by N array to a m by n, where
m and n are variables?

 

[Alan Beban]

How do I resize a named array in Excel from a M by N array to a m by n, where
m and n are variables?

Huh?

Alan Beban

 

[Gary Brown]

Either...

Redim NamedArray(m,n)

or if you don't want to lose the cdurrent array contents
when reallocating use...

ReDim Preserve NamedArray(m,n)

HTH,
Gary Brown

 

[Guest]

Look at the ReDim statement in the online-help.
It can only be done with dynamic array:
Eg:
Dim v() as string, v1(2,2) as string
'V1 cannot be re-dimensioned
'For V:
Redim V(1 to 2, 1 to 2)
v(1,1)="hello"
Redim V(1 to 3, 1 to 3) 'above , v is re-dimensioned... v(1,1) is now
empty-string
v(1,1)="world"
Redim Preserve V(1 to 3, 1 to 5) ' By using Preserve you can
re-dimension the
' last dimension of the array without loosing its values, ie
here,
' v(1,1) is still "world"
' but you can only do that on the last dimension.

Regards,
Sebastien

 

[Alan Beban]

How do I resize a named array in Excel from a M by N array to a m by n, where
m and n are variables?

Well, you've got a couple of partial answers.

What's the difference between your M by N array and the resized array
that is m by n? Is M by N different from m by n??? How is the M by N
array declared?

Alan Beban

 

[RB Smissaert]

Alan,

Doesn't the OP just want your ArrayTranspose function?
Or the Excel worksheet function Transpose?

RBS

 

[Tom Ogilvy]

doesn't sound like it

M X N could be 5 x 6 while m x n could be 2 x 15 or 3 x 10 for example.

 

[Alan Beban]

doesn't sound like it

M X N could be 5 x 6 while m x n could be 2 x 15 or 3 x 10 for example.

Or 13 by 17. Once you posit that m is a different size number than M,
there's no reason to think M*N=m*n, unless one were supposed to think
that that was implicit in the use of the word "resize".

And if something like the Transpose were sought, one would think that
the request would be about "resizing" from M by N to N by M.

Hey, the OP seems to be happy with the less than complete answers, so if
he/she is happy I can be happy for him/her.

Alan Beban

 

[Harlan Grove]

Or 13 by 17. Once you posit that m is a different size number than M,
there's no reason to think M*N=m*n, unless one were supposed to think
that that was implicit in the use of the word "resize".

....

Depends on whether the OP is used to different programming languages. FWLIW,
in APL

A is 6 5 rho iota 30

creates a 6 by 5 array like {1,2,3,4,5;6,..,10;...;26,..,30}, and

B is 3 11 rho A

is well-defined as

{1,2,..,11;12,13,..,22;23,24,..,30,1,2,3}

It's all a matter of where one's coming from, which the OP should have
stated.