How about using dependents to get back
Ctrl+G, special, [x] dependents
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dmitry Kopnichev" wrote in message ...
My selection was moved to another sheet by clicking on the precedents arrow
and I want to come back to the analyzed cell.
"Norman Jones" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
Hi Dmitri,

Try something like:

'===================
Public Sub Tester03()
Dim rng As Range
Dim rCell As Range

Set rng = Selection
Set rCell = ActiveCell

'your code, e.g.
Range("A1").Select

rng.Select
rCell.Activate

End Sub
'<<===================

However, the above code would not normally be needed because it is rarely
necessary, or desirable, to make selections,


---
Regards,
Norman



"Dmitry Kopnichev" wrote in message
...
Hello
How to go back to last selected cells?