HypDeleteLROs

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: For future use. Currently the active sheet 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) As Long

Sub HypDeleteLROs()
sts = HypDeleteLROs("Sheet1", Range("B3"), LROIDs)
End Sub