Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypSetCellsDirty() marks selected data range dirty for submit data.
HypSetCellsDirty (vtSheetName, vtRange)
ByVal vtSheetName As Variant
ByVal vtRange As Variant
vtSheetName: For future use. Currently the active sheet is used.
vtRange: Variant data range to be marked as dirty.
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 SetDirtyCells()
X=HypSetCellsDirty (Empty, Range (“A3:B3”)
End Sub