XLGOTOCELL command

Moves the cursor position in the current sheet.

Syntax

CHGVAR VAR(&CMD)VALUE('XLGOTOCELL')

CHGVAR VAR(&PARM1)VALUE('coordinates')

CHGVAR VAR(&PARM2)VALUE(' ')

CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT +

&PARM1 &PARM2 &RESULT)

Parameters

Parm1

The coordinates of the destination cell.

The coordinates can be given in the form:
- Syntax $B$3. Example: $B$3 is column B, line 3.
- Symbolic name given to a cell or group of cells.

Example

CHGVAR VAR(&CMD)VALUE('XLGOTOCELL')

CHGVAR VAR(&PARM1)VALUE('Sum')

CHGVAR VAR(&PARM2) VALUE(' ')

CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT +

&PARM1 &PARM2 &RESULT)

CHGVAR VAR(&CMD)VALUE('XLGOTOCELL')

CHGVAR VAR(&PARM1)VALUE('$B$3')

CHGVAR VAR(&PARM2) VALUE(' ')

CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT +

&PARM1 &PARM2 &RESULT)

See also

• XLCELLNAME