transpose
How does one transpose a VBA array? In the following the result of lines 3
and 5 are the same.
Sub zz()
Dim x(3, 2)
3 Debug.Print UBound(x, 1), UBound(x, 2)
WorksheetFunction.Transpose (x)
5 Debug.Print UBound(x, 1), UBound(x, 2)
End Sub
--
Thanks for your help
|