I have a 1x3 vector, "Watches" type is Variant/Variant(1 to 3), that I what to transpose with the Application.Transpose command. After the command executes the Vector is not a proper 3x1 but appears to have added another column, "Watches" type is Variant/Variant(1 to 3, 1 to 1). I would have expected "Watches" type is Variant/Variant(3 to 1). This causes problems later in my code. What is really happening?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Application.Transpose Appears to be Adding Row to Vector
- Thread starter JosephAE
- Start date
