Activate Excel when double click

[Ran @Comverse]

Hi,

My issue is as follows: I have 2 applicaions open when one of them is Excel
(2007).
The active window is the second applicaion and now I double click on a cell
in Excel which is different than the cell which I was on it in my last
session in Excel.

The event "Beforedouble click" for exmple will rise on the previous cell
which I was on it.

How can I make this event to rise on the new cell which I selected now?

Thanks,
Ran.

 

[Peter T]

Are you sure Target refers to the previous cell. For me it refers to the
actual double clicked cell, even if the first click re-activates Excel to
select the new cell.

Include this in the event -
Debug.Print Target.Address

Regards,
Peter T