Maybe a couple of macros you could assign hotkeys to or assign to a button?

Before you start jumping run startfrom macro.

Sub startfrom()
Set currentSelection = Application.ActiveCell
currentSelection.Name = "startcell"
End Sub

Do your monkeying around then run gobackto macro

Sub gobackto()
Range("startcell").Select
End Sub

Note.........running these will clear the undo stack so make sure it is worth
it.


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 15:00:01 -0700, raulavi
wrote:

thanks guys ,,, that helps, but I will do some monkey around before returnig
to my cell.

so, we need a way to tag the cell (hot key or mouse) ,monkey around
,hotkey(to go back to it)....people familiar with developing can see how
important is this featu be able to back track your step(no undo) , as the
undo key (the miracle feature)

"raulavi" wrote:

excel 2007
How can you jump back to the same cell after jumping around?
I want to mark a cell then after scrolling around I want to return to it, I
dont want to use reference or name the cell, this is an every day process.