WorksheetFunction.Transpose Method
Returns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE must be entered as an array formula in a range that has the same number of rows and columns, respectively, as an array has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array on a worksheet.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Transpose ( _
Arg1 As Object _
) As Object
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim returnValue As Object
returnValue = instance.Transpose(Arg1)
Object Transpose(
Object Arg1
)
Parameters
Arg1
Type: System.ObjectArray - an array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on.
Return Value
Type: System.Object