Application.Transpose Appears to be Adding Row to Vector

JosephAE

New Member
Joined
Jan 25, 2018
Messages
1
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?
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,095,360
Messages
5,444,015
Members
405,260
Latest member
Khauff

This Week's Hot Topics

Top