Active / Selected Cell

[ken gray]

is there a way to get the location of the currently active cell in Excel?

[Gintaras]

Macro Macro1640

Code:

Copy      Help

ExcelSheet es.Init
Excel.Range r=es.ws.Application.ActiveCell
out r.Address(@ @ 1)
out r.Column
out r.Row

[Gintaras]

In next QM will be special range string "<active>", to use with ExcelSheet functions. And new function GetRangeInfo.

Code:

Copy      Help

int c1 r1 nc nr
es.GetRangeInfo("<active>" c1 r1)
out "%i %i" c1 r1

[ken gray]

ty.