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)
HypPivot() transposes spreadsheet rows and columns, based on the selected dimension.
HypPivot(vtSheetName, vtStart, vtEnd)
ByVal vtStart As Variant
ByVal vtEnd As Variant
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
Returns 0 if successful; otherwise, returns the appropriate error code.
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