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