How to go back to last selected cells?

  • Thread starter Dmitry Kopnichev
  • Start date
N

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,
 
D

Dmitry Kopnichev

My selection was moved to another sheet by clicking on the precedents arrow
and I want to come back to the analyzed cell.
 
D

Dmitry Kopnichev

There are too many dependents! Which one to choose? The dependents paths are
too long for the window where I have to choose.
David McRitchie said:
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 said:
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" <[email protected]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:[email protected]...
Click to expand...
Click to expand...
 
Top