Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to go back to last selected cells?
Hello
How to go back to last selected cells? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
Have you tried F5?
Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
changing the way Excel displays selected cells | Excel Discussion (Misc queries) | |||
Excel will not add cells automatically together when selected? | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) |