Returns a vertical range of cells as a horizontal range, or vice versa.
Object Model
Syntax
'Declaration Public Class CalcTransposeFunction Inherits CalcBuiltinFunction
'Usage Dim instance As CalcTransposeFunction
public class CalcTransposeFunction : CalcBuiltinFunction
Remarks
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.
Inheritance Hierarchy
System.Object
GrapeCity.CalcEngine.Functions.CalcFunction
GrapeCity.CalcEngine.Functions.CalcBuiltinFunction
GrapeCity.CalcEngine.Functions.CalcTransposeFunction
See Also