WS function

  • Thread starter Thread starter jacob
  • Start date Start date
J

jacob

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(AllData)
Redim AllData(1 to ubound(AllData,1), 1 to Ubound
(AllData,2)+1)
AllData=Application.Worksheetfunction.Transpose(AllData)

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

oj
 
Found out: For Excel 2000, if no of elements exceeds 5461
the transpose function does not work and returns error
message # 13, type mismatch.
 
Back
Top