How to go back to last selected cells?

  • Thread starter Thread starter Dmitry Kopnichev
  • Start date Start date
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,
 
My selection was moved to another sheet by clicking on the precedents arrow
and I want to come back to the analyzed cell.
 
How about using dependents to get back
Ctrl+G, special, [x] dependents
 
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


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...
 
Have you tried F5?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Go to Last edited cell 3
Go back to last selected Worksheet 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Go to cell below last entry in column and total 1
Go back to last step in programming 2
How can I move to the first cell in the selection in Excel 07? 7
Find second to last value in cell 4

Back
Top