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