"ActiveCell" in another sheet...
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
|