HypConsolidateAllWithData
Data provider types: Oracle Hyperion Financial Management (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: 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 HypConsolidateAllWithData Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long
Sub Example_HypConsolidateAllWithData()
sts = HypConsolidateAllWithData (Empty, Empty)
End Sub