hi,

this isn't possible, but it is possible to select a sheet without that
being visible

Sub Macro1()
Dim sh As String
sh = ActiveSheet.Name
Application.ScreenUpdating = False
Sheets("Sheet2").Select
x = ActiveCell.Address
Sheets(sh).Select
Application.ScreenUpdating = True
MsgBox x
End Sub

isabelle

Le 2013-09-19 15:13, witek a écrit :
is there a way to find out which cell will be ActiveCell when sheet is
selected without selecting it?

Each sheet remebers last position of active cell so when you return to
that sheet the same cells becomes active.
I need to know the address of last active cell on each sheet.


it is probably even more complicated because as I see each window of
the same document can have different activecell on the same sheet.