Hi,

I would likel to retrieve the position of the cell that would be current if
I activate a particuler sheet.

My scenario is :
- updating something in the current sheet hides rows in another sheet
- if a row I hide contains the "current cell", the method fails.

I see Application.ActiveCell but that is the cell that has the focus in the
current sheet. I would like to get the cell that would have the focus in
another sheet that is currently not activated.

TIA

--
Patrice

Solved. Actually I don't need any more this info in my scenario (not sure if
usefull on some other occasion ?)

--
Patrice

"Patrice" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
> Hi,
>
> I would likel to retrieve the position of the cell that would be current
> if I activate a particuler sheet.
>
> My scenario is :
> - updating something in the current sheet hides rows in another sheet
> - if a row I hide contains the "current cell", the method fails.
>
> I see Application.ActiveCell but that is the cell that has the focus in
> the current sheet. I would like to get the cell that would have the focus
> in another sheet that is currently not activated.
>
> TIA
>
> --
> Patrice
>
>
>