HypConsolidateAllWithData

Data source types: Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)

Description

HypConsolidateAllWithData calls the Consolidate All With Data method.

Syntax

HypConsolidateAllWithData (vtSheetName, vtRange)

ByVal vtSheetName As Variant

By Val vtRange As Variant

Parameters

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.

Return Value

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

Example

Declare Function HypConsolidateAllWithData Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long

sts = HypConsolidateAllWithData  (Empty, Empty)