How do I transpose a matrix in Excel using FormulaArray?
I defined a range object and assigned it to a numeric matrix, then I attempted to use FormulaArray to transpose it and put it into Range(Cells(5, 1), Cells(6, 2)). But where's the bug?
Željko Petrušić's answer to How do I transpose a matrix in Excel using FormulaArray? - Quor
This one is easy. One can use Excel built-in functionality to achieve the goal... [code] Sub CopyAndTranspose() On Error GoTo ErrorHandler Dim oWs As Wo...