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" 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

For future reference, there is no active cell or current cell in a closed
workbook. The workbook must be open for either to be used as a reference.
All references from an active workbook to a closed workbook must be explicit.

"Patrice" wrote:

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