| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array size limit when using WorksheetFunction.Transpose?
I'm getting Run-time error '13': Type mismatch when using...
Range("B1").Resize(UBound(vaArray, 2), 2).Value = Application.WorksheetFunction.Transpose(vaArray) to get vaArray onto the worksheet and the number of columns in the array is greater than something like 2730. I can't find any mention of such a limit in my researches. Does anybody know of such a limit and its cause? Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an array size limit for MMULT or MINVERSE in excel 2007? | Excel Worksheet Functions | |||
| Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
| what is array size limit in VBA? | Excel Programming | |||
| worksheetfunction.transpose - nx1 to n element? | Excel Programming | |||
| limit to possible array size? | Excel Programming | |||
Threaded Mode
