Dear Fellow Members,
I am looking for an faster alternative to this code:
Application.Index(rngParameters, 1) = Application.Index(varTests, t, 5)
Application.Index(rngParameters, 2) = Application.Index(varTests, t, 6)
Application.Index(rngParameters, 3) = Application.Index(varTests, t, 7)
Application.Index(rngParameters, 4) = Application.Index(varTests, t, 8)
Application.Index(rngParameters, 5) = Application.Index(varTests, t, 9)
Application.Index(rngParameters, 6) = Application.Index(varTests, t, 10)
Here I transpose six consecutive columns from a raw (number "t") in an internal array ("varTests") into a similar size vertical vector in the worksheet (named here "rngParameters").
Please note six elements are: (1) a consecutive part (colums in a row) of the array; (2) the entire vertical vector size in Excel (it includes six rows).
There should be a faster way…
Please advise.
THX
I am looking for an faster alternative to this code:
Application.Index(rngParameters, 1) = Application.Index(varTests, t, 5)
Application.Index(rngParameters, 2) = Application.Index(varTests, t, 6)
Application.Index(rngParameters, 3) = Application.Index(varTests, t, 7)
Application.Index(rngParameters, 4) = Application.Index(varTests, t, 8)
Application.Index(rngParameters, 5) = Application.Index(varTests, t, 9)
Application.Index(rngParameters, 6) = Application.Index(varTests, t, 10)
Here I transpose six consecutive columns from a raw (number "t") in an internal array ("varTests") into a similar size vertical vector in the worksheet (named here "rngParameters").
Please note six elements are: (1) a consecutive part (colums in a row) of the array; (2) the entire vertical vector size in Excel (it includes six rows).
There should be a faster way…
Please advise.
THX