GRID.GetRange

range = GRID.GetRange( BYVAL nControl AS INTEGER,

                       BYVAL nRange   AS INTEGER,

                       BYVAL nValue   AS INTEGER,

                      [BYVAL strName  AS STRING] ) AS INTEGER

Gets the current selected, data or named range.  The value parameter determines which part of a range is to be returned.

The following constants have been defined:

' Get/Set Range Types

CONST MG_RANGE_DATA        = 1

CONST MG_RANGE_SELECTED    = 2

CONST MG_RANGE_NAMED       = 3

' GetDataRange Return Value Types

CONST MG_GET_MINROW        = 1

CONST MG_GET_MINCOL        = 2

CONST MG_GET_MAXROW        = 3

CONST MG_GET_MAXCOL        = 4

CONST MG_GET_ROWCOUNT      = 5

CONST MG_GET_COLCOUNT      = 6

Example:

' Reset Data Range to default (entire sheet)

GRID.SetRange( nControl, MB_RANGE_DATA )

' Display Data Range

PRINT "Data Range: "

PRINT GRID.GetRange( nControl, MB_RANGE_DATA, MG_GET_MINROW );", "

PRINT GRID.GetRange( nControl, MB_RANGE_DATA, MG_GET_MINCOL );", "

PRINT GRID.GetRange( nControl, MB_RANGE_DATA, MG_GET_MAXROW );", "

PRINT GRID.GetRange( nControl, MB_RANGE_DATA, MG_GET_MAXCOL ),