Data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Planning and Budgeting Cloud ad hoc only), Oracle Hyperion Financial Management (ad hoc only)
Description
HypRemoveOnly() removes only the selected member(s) in the worksheet.
Selection must include only member cells, not data cells.
Syntax
HypRemoveOnly(vtSheetName, vtSelection)
ByVal vtSheetName As Variant
ByVal vtSelection 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.
vtSelection: The range object that refers to the member(s) to be removed. If selection is Null or Empty, the active cell is used.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Examples
To remove only one member name:
Public Declare Function HypRemoveOnly Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtSelection As Variant) As Long Sub Example_HypRemoveOnly() X=HypRemoveOnly(Empty, RANGE("D2")) If X = 0 Then MsgBox("Remove Only successful.") Else MsgBox("Remove Only failed." + X) End If End Sub
To remove multiple member names:
Public Declare Function HypRemoveOnly Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtSelection As Variant) As Long Sub Example_HypRemoveOnly() X=HypRemoveOnly(Empty, RANGE("D2, A5")) If X = 0 Then MsgBox("Remove Only successful.") Else MsgBox("Remove Only failed." + X) End If End Sub