How to go back to last selected cells?
 

Hello
How to go back to last selected cells?

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?

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?

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?

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" wrote in message
...
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?

Have you tried F5?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

I have not tried F5.
"Bill Manville" ???????/???????? ? ????????
?????????: ...
Have you tried F5?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup