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?

OddajP. J., dne 2015-10-12 ob 20:05:42

Ž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...

profileimage
Všeč mi je
0
Komentarji
0
Ni komentarjev
P. J.
P. J.
Objavil/a 2015-10-12 20:05:42 (Oct 12, 2015)
Starejša objava Novejša objava
ZADNJI KOMENTARJI
KATEGORIJE
IŠČI PO ARHIVU
junij 2019
PTSČPSN
12
3456789
10111213141516
17181920212223
24252627282930
Zapri predvajalnik
Prikaži seznam predvajanja
Prestavi predvajalnik
Povečaj