HypSetCellsDirty
Describes the Oracle Smart View for Office VBA function, HypSetCellsDirty.
Data provider types: Oracle Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
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