Transpose

The Transpose method transposes the row and column data in the WksRange object.

Syntax

object.Transpose()

Example

The following example specifies a 3 column and 2 row range and transposes the data.

'Set range

Set WksRange = Wks.Range(Row:=1, Col:=1, LastRow:=2, LastCol:=3)

 

'Transpose data

WksRange.Transpose()

Used by: WksRange object