Data provider types: Financial Management
HypForceCalculate() calls the Force Calculate method.
HypForceCalculate(vtSheetName, vtRange)
By Val vtRange As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtRange: The range that contains the data to be used. If Empty or Null, the selected range in the worksheet is used.
Returns 0 if successful; otherwise, returns the corresponding error code.
Declare Function HypForceCalculate Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long Sub Example_HypForceCalculate() sts = HypForceCalculate (Empty, Empty) End Sub