Data provider types: Essbase
HypDeleteLROs() deletes one or more linked reporting objects from the cells specified by the vtSelectionRange parameter.
HypDeleteLROs (vtSheetName, vtSelectionRange, vtLROIDs())
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByRef vtLROIDs() As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtSelectionRange: Input variable; the range of cells from which to delete all linked reporting objects
vtLROIDs(): Input variable; the array of LRO Ids to be deleted
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypDeleteLROs Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant, ByRef vtLROIDs() As Variant) As Long Sub Example_HypDeleteLROs() Dim LROIDs(1) LROIDs(0) = 1 LROIDs(1) = 2 sts = HypDeleteLROs("Sheet1", Range("B3"), LROIDs) End Sub