Thread: WS function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Jacob is offline
external usenet poster
 
Posts: 26
Default 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