converting array to Range using function.transpose - maximum size

[Rasm]

Is there a maximum size of the array when moving data as this:


ActiveSheet.Range(Astr).Value = Application.WorksheetFunction.Transpose(TemPvalues)


The array is declared like this


Dim TemPvalues() as string

ReDim TemPvalues(ColLast - ColFirst + 1, NumTot)

where

ColLast - ColFirst + 1= 700

NumTot=15000

Astr contains 700 columns and 15000 Rows


FYI - I am reading the data from other file types - so importing data into Excel

 

[shg]

What happens when you try?

 

[Rasm]

The cells are blank - I tried with fewer records - like 6 samples by 640 datapoints per sample - that works. When I do the big array - I dont even get an error - just balnk cells. Could it be that the array size is limited to 2^16 or 65536 elements?

 

[Rasm]

ahhh - I may be mistaken - let me double check - sorry

 

[Rasm]

SHG - It was my mistake - I have different device platform as my datasource - it was a problem with a specific device - It does covert the large arrays. Sorry to put you on a goose chase.