HypConsolidateAll
Describes the Oracle Smart View for Office VBA function, HypConsolidateAll.
Data provider types: Oracle Hyperion Financial Management (ad hoc only)
Description
HypConsolidateAll() calls the Consolidate All method.
Syntax
HypConsolidateAll (vtSheetName, vtRange)
ByVal vtSheetName As Variant
By Val vtRange 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.
vtRange: The range that contains the data to be used. If Empty
or Null
, the selected range in the worksheet is used.
Return Value
Returns 0 if successful; otherwise, returns the corresponding error code.
Example
Declare Function HypConsolidateAll Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long
Sub Example_HypConsolidateAll
sts = HypConsolidateAll(Empty, Empty)
End Sub