Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use the Transpose function to turn the one column into one row
Sub TransposeArray()
    Dim myArray As Variant
   myArray = WorksheetFunction.Transpose(range("myTran"))
   MsgBox "The 5th element of the Array is: " & myArray(5)
End Sub