View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrice[_4_] Patrice[_4_] is offline
external usenet poster
 
Posts: 2
Default "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