Please enable JavaScript to view this site.

thinBasic Help Manual

* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *

This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.

This version is copyright and may only be used for local testing purposes. It may not be distributed.

Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.

 

Description

 

Returns the sum of numeric values present in a grid range.

 

Syntax

 

n = MLGrid_Sum_Range(hGrid, Col [, Col_From [, Row_from [, Row_To [, Sheet]]]] )

 

Returns

 

Number

 

Parameters

 

Name

Type

Optional

Meaning

hGrid

Number

No

handle to grid control, the one returned by CONTROL ADD MLGRID ...

Col_From

Number

No

column number to start from

Col_To



column number to end to

If Col_To = -1 it will be set to Col_From

If omitted, total number of columns will be used

Row_From

Number

Yes

row number to start from.

If omitted 1 will be used

Row_To

Number

Yes

row number to end to.

If Row_To = -1 it will be set to Row_From

If omitted total number of rows will be used

Sheet

Number

Yes

number of the sheet in a workbook.

If omitted, current selected sheet will be used

 

Remarks

 

Restrictions

 

See also

 

Examples

 

 

 

Created with Help+Manual 8 and styled with Premium Pack Version 4 © by EC Software