Application.Transpose(junk_array) .....gives type mismatch error

Hi,

I get a run time error in my code when i take an array such as this

Please Login or Register  to view this content.

apparently when you try to transpose an array such as the one above and it has more than ~65000 elements and you then use this

Please Login or Register  to view this content.

you get a type mismatch error



anyone know of a workaround?

Hi,
just for example

Please Login or Register  to view this content.

thanks...........is there a "faster" way to transpose the array?

There is interesting discussion of transposing here: http://www.vbaexpress.com/forum/show...rther-analysis

I will take a look at it. thanks.

Originally Posted by welchs101

..is there a "faster" way to transpose the array?

I think this is a faster way to fill the output array at a time when unique keys fall into the dictionary (You use the dictionary, is not it?)

nilem, not sure I understand........can you give example.....does not have to be a detailed example just something to help me understand

here you go

Please Login or Register  to view this content.

welchs101

No need to prepare output array

Please Login or Register  to view this content.

i will take a look at the codes .......... as usual I will probably have questions.

thanks!

quick question:
Now the "application.transpose(junk_arry)" will produce a runtime type mismatch error when junk_array contains more than say 2^16 values.

Will the "Resize" function also have the same problem? I am not at a computer that has excel 2007 or higher right now so I can not test. But this was my first questions.

Second question is this. The application.transpose function does not really work for when an array has more than 2^16 elements in it....is there a web site, paper, book, or something one can reference to view "other" similar type issues. I hate finding out "after the fact" that some piece of code does not work because of a size limitation.

The size of array depends on the memory.

Please Login or Register  to view this content.

As I mentioned in the other thread, loop is the fastest afaik.