Hello all,
I got the following array (see picture). I would like to use the following line to copy the array. How do I change the array b to get it to work?
Range(Cells(0, 0), Cells(0, UBound(a, 1))).Value = Application.Transpose(Application.Index(a, 1, 0))
/R
I got the following array (see picture). I would like to use the following line to copy the array. How do I change the array b to get it to work?
Range(Cells(0, 0), Cells(0, UBound(a, 1))).Value = Application.Transpose(Application.Index(a, 1, 0))
/R