HypPivot

Data provider types: Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)

Description

HypPivot() transposes spreadsheet rows and columns, based on the selected dimension.

Syntax

HypPivot(vtSheetName, vtStart, vtEnd)

ByVal vtSheetName As Variant

ByVal vtStart As Variant

ByVal vtEnd As Variant

Parameters

vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.

vtStart: The range object that refers to the single cell starting point of the pivot

vtEnd: The range object that refers to the single cell ending point of the pivot

Return Value

Returns 0 if successful; otherwise, returns the appropriate error code.

Example

Public Declare Function HypPivot Lib "HsAddin" (ByVal vtSheetName As Variant,  ByVal vtStart As Variant, ByVal vtEnd As Variant) As Long

Sub Example_HypPivot()
X=HypPivot(Empty, RANGE("B2"), RANGE("D1"))
   If X = 0 Then
      MsgBox("Pivot successful.")
   Else
      MsgBox("Pivot failed.")
   End If
End Sub