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.

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


"Ran @Comverse" <(E-Mail Removed)> wrote in message
news:0CBA045C-81E5-40F4-9709-(E-Mail Removed)...
> 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.