View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrice[_4_] Patrice[_4_] is offline
external usenet poster
 
Posts: 2
Default "ActiveCell" in another sheet...

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

--
Patrice

"Patrice" a écrit dans le message de news:
...
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