Web Development

Ask something
Discussion Locked

TransposeFunctionalityin ExcelWorksheet?

0 helpful
1 reply

by r_nair83

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have never used this Transpose Function before.
Can anyone help me with Code so that I can transpose rows into columns and vice versa, using VB.net Code.
Thanks.

1 reply

by rkuhn040172

In VBA for cells A1 thru C1:

Sub Macro()

Selection.FormulaArray = "=TRANSPOSE(R[-1]C:R[1]C[2])"

End Sub

This discussion is closed to new replies.