Here’s an odd one, I think. I have code that creates a two-dimensional array and I want to use Application.WorksheetFunction.Transpose to switch the rows and columns.
Sub TestTrans()
Dim aTest(0 To 3, 0 To 1) As Long
Dim vaTrans As Variant
Dim i As Long, j As Long
[...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/06/09/transpose-changes-array-dimension/
Posted
Jun 09 2011, 05:51 PM
by
Daily Dose of Excel