WS function
 

Hi,
I have a dynamically sized matrix which I redimension
in both dimensions using the Transpose function. This
works fine in XP. Using it in version 9 I get error 13 -
Type mismatch - when transposing, but only when the
matrix dimensions exceed some limit. Code looks like this:

Dim AllData() as Variant
..
..
..
AllData=Application.Worksheetfunction.Transpose(Al lData)
Redim AllData(1 to ubound(AllData,1), 1 to Ubound
(AllData,2)+1)
AllData=Application.Worksheetfunction.Transpose(Al lData)

Are there any known limitations in Excel cversions
earlier than XP? Any help appreciated.

oj

WS function
 

Found out: For Excel 2000, if no of elements exceeds 5461
the transpose function does not work and returns error
message # 13, type mismatch.
-----Original Message-----
Hi,
I have a dynamically sized matrix which I redimension
in both dimensions using the Transpose function. This
works fine in XP. Using it in version 9 I get error 13 -
Type mismatch - when transposing, but only when the
matrix dimensions exceed some limit. Code looks like
this:

Dim AllData() as Variant
..
..
..
AllData=Application.Worksheetfunction.Transpose(A llData)
Redim AllData(1 to ubound(AllData,1), 1 to Ubound
(AllData,2)+1)
AllData=Application.Worksheetfunction.Transpose(A llData)

Are there any known limitations in Excel cversions
earlier than XP? Any help appreciated.

oj
.