Home |
Search |
Today's Posts |
#1
|
|||
|
|||
shortcut to go to previous location or cell
Is there a shortcut to take me back to the previous location (cell) that I
was in? |
#2
|
|||
|
|||
shortcut to go to previous location or cell
If there was an action done in the previous cell,
then perhaps ... click Undo? (At the expense of undoing, of course, and subject to the default max number of undo's) Hang around awhile for better answers .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Jan" wrote in message ... Is there a shortcut to take me back to the previous location (cell) that I was in? |
#3
|
|||
|
|||
shortcut to go to previous location or cell
Hi Jan,
Maybe you can create a macro solution: Create workbook-level public variables: Private Sub Workbook_Open() startcell = ActiveCell.Address prevcell = "" End Sub Selection_Change event: Private Sub Worksheet_SelectionChange(ByVal Target As Range) prevcell = startcell startcell = Target.Address End Sub Normal module: Declarations Public startcell As String Public prevcell As String Macros, assign a hotkey to this macro in : Sub Goback() Range(prevcell).Select End Sub Regards, Stefi €˛Jan€¯ ezt Ć*rta: Is there a shortcut to take me back to the previous location (cell) that I was in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Excel 2003 have a shortcut command to wrap text in a cell? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
input value in a cell when the previous cell is greater than 0 | New Users to Excel |