Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Active / Selected Cell
#1
is there a way to get the location of the currently active cell in Excel?
An old blog on QM coding and automation.

The Macro Hook
#2
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
#3
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
#4
ty.
An old blog on QM coding and automation.

The Macro Hook


Forum Jump:


Users browsing this thread: 1 Guest(s)