Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management


HypSetCellsDirty() marks selected data range dirty for submitting data.


HypSetCellsDirty (vtSheetName, vtRange)

ByVal vtSheetName As Variant

ByVal vtRange As Variant


vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.

vtRange: Variant data range to be marked as dirty

Return Value

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


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

Sub Example_HypSetCellsDirty()
   X=HypSetCellsDirty (Empty, Range ("A3:B3"))
End Sub