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
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 .
Thanks, oXL.Activecell.Address solved my problem
MSFT's documentation for Excel COM Automation objects can be found here:
https://docs.microsoft.com/en-us/office/vba/api/overview/excel (https://docs.microsoft.com/en-us/office/vba/api/overview/excel)