|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > UI (User Interface) > CONTROLS > Control Types > MLGrid Control > MLGrid Control Commands > MLGrid_Sum_Range |
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