HypForceCalculate

Data source types: Financial Management

Description

HypForceCalculate() calls the Force Calculate method for Financial Management data sources.

Syntax

HypForceCalculate(vtSheetName, vtRange)

ByVal vtSheetName As Variant

By Val vtRange As Variant

Parameters

vtSheetName: For future use. Currently the active sheet is used.

vtRange: Range object which refers to the data to be used. Passing an empty or null parameter uses the current selection from the sheet.

Return Value

Returns 0 if successful; otherwise, returns the corresponding error code.

Example

Declare Function HypForceCalculate Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long

sts = HypForceCalculate (Empty, Empty)