IPrxFormulaIsland.Range

Syntax

Range: ITabRange;

Description

The range property determines range of cells of the formula area.

Example

Sub Main;

Var

MB: IMetabase;

Report: IPrxReport;

FormulaIs: IPrxFormulaIslands;

Formula: IPrxFormulaIsland;

Range: ITabRange;

s: String;

Begin

MB := MetabaseClass.Active;

Report := MB.ItemById("Report").Bind As IPrxReport;

FormulaIs := Report.FormulaIslands;

Formula := FormulaIs.Item(0);

Range := Formula.Range;

s := Range.Address;

End Sub Main;

After executing the example the "s" variable contains address of the cell range of the first formula area. The identifier of the regular report - Report.