Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management, Oracle Hyperion Enterprise®
Description
HypSetCellsDirty() marks selected data range dirty for submitting data.
Syntax
HypSetCellsDirty (vtSheetName, vtRange)
ByVal vtSheetName As Variant
ByVal 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: Variant data range to be marked as dirty
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
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