Previous - xlsAddSheet Section Home - Microsoft Excel Next - xlsWidth


xlsSetRange ( )

Selects an cell range for editing

Usage:

xlsSetRange (object me, integer x0, integer y0, integer x1, integer y1 )

Parameters:

x0 (integer) - left cell index number for starting cell

y0 (integer) - top cell index number for starting cell

x1 (integer) - left cell index number for ending cell

y1 (integer) - top cell index number for ending cell

Returns:

(integer) - The success code

Example:

xtRose = xtra("Rosetta").new( )
xtRose.xlsLaunch( )
xtRose.xlsNewBlank( )
xtRose.xlsSetRange( 1, 1, 5, 3 ) -- selects a range with a width of 5 cells and a height of 3 cells

Notes:


Previous - xlsAddSheet Section Home - Microsoft Excel Next - xlsWidth