Excel OLE active cell coordinates

Started by JohnR, February 26, 2019, 08:18:15 PM

Previous topic - Next topic

JohnR

Hello,
I am trying to determine what the active cell coordinates are in an Excel worksheet, that has been opened by the OLE/COM, and the user has moved the active cell.
Any help would be much appreciated.
Thanks
John

stanl

Assuming your Excel Object is something like oXL, then oXL.Activecell.Address - but your post implies the user is in charge not the script, in which case I would suggest writing worksheet code for an Excel event such as OnChange (which doesn't really apply here), or have your script using a callback with a timer to report the active cell, which sounds like a waste.


Maybe provide more detail .

JohnR

Thanks, oXL.Activecell.Address solved my problem

td

"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade