Data provider types: Oracle Essbase
Description
HypDeleteAllLROs() deletes all linked reporting objects from the cells specified by the vtSelectionRange parameter.
Syntax
HypDeleteAllLROs (vtSheetName, vtSelectionRange)
ByVal vtSheetName As Variant
ByVal vtSelectionRange 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.
vtSelectionRange: The range of cells from which to delete all linked reporting objects
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypDeleteAllLROs Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant) As Long
Sub Example_HypDeleteAllLROs
sts = HypDeleteAllLROs("Sheet1", Range("B3"))
End Sub