Data source types: Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypConsolidateAll() calls the Consolidate All method.
HypConsolidateAll (vtSheetName, vtRange)
ByVal vtSheetName As Variant
By Val vtRange As Variant
vtSheetName: For future use. Currently the active sheet is used.
vtRange: Range object which refers to the data to be used. Passing an empty or null parameter uses the current selection from the sheet.
Returns 0 if successful; otherwise, returns the corresponding error code.
Declare Function HypConsolidateAll Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long
sts = HypConsolidateAll (Empty, Empty)