Transpose Method
The Transpose method converts the selected columns to rows or rows to columns, similar to the Transpose command in the worksheet. Returns a Boolean.
Syntax
object.Transpose( FirstRow, FirstCol, LastRow, LastCol )
Parameter | Type | Description |
FirstRow | Long | required, first row containing values to transpose |
FirstCol | Long | required, first column containing values to transpose |
LastRow | Long | required, last row containing values to transpose |
LastCol | Long | required, last column containing values to transpose |
Example
This example demonstrates how to transpose a column of numbers starting at row 1 and ending at row 15 into a row or columns.
Wks.Transpose(1,1,15,1)
Used by: Worksheet object