Transpose

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using

rngOut.Value = Application.WorksheetFunction.Transpose(Temp)

in code. Normally this works just fine but every once in i while I get a
type mismatch error. I know in Excel 2000 there was a limit to how many
elements could be contained in the vector to transpose. Is there a similar
limitation for XP?
 
Is there a similar | limitation for XP?

Sure. You might search the MSKB on "array limits". Here's one article:

http://support.microsoft.com/?id=166342

--
Jim Rech
Excel MVP
| Using
|
| rngOut.Value = Application.WorksheetFunction.Transpose(Temp)
|
| in code. Normally this works just fine but every once in i while I get a
| type mismatch error. I know in Excel 2000 there was a limit to how many
| elements could be contained in the vector to transpose. Is there a similar
| limitation for XP?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WS function 1
Code character limit with Resize or Transpose or cell? 8
Referring to ranges as Cell, Range, and variables 6
need a robust transpose(array) function 1
Eliminate blanks while copy row and transpose 11
Array size limit when using WorksheetFunction.Transpose? 6
macro - paste special (transpose) 5
Transpose code has ceased to transpose 3

Back
Top