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.