If you don't want to name a range, Excel internally stores up to 4 previous
GoTo's.
Prior to Excel 2007, I had a toolbar button that ran the following.
Hit F5 to "GoTo" another area. Then I'd click a toolbar button to go back.

Sub GoBack1()
Application.PreviousSelections(1).Select
End Sub

--
HTH :)
Dana DeLouis
I really hate Excel 2007.


"Dave Peterson" wrote in message
...
If you've changed sheets or workbooks, then that code will have trouble.

Change to the correct workbook (if you need to), then try this code:

Option Explicit
Sub gobackTOcell()
On Error Resume Next
Application.Goto "startcell"
If Err.Number < 0 Then
Beep
Err.Clear
End If
On Error GoTo 0
End Sub


raulavi wrote:

Am i missing too much?
this is my 1st macro...
knowing this ...
I got Run-time error '424'
object required

my Macro is

Sub gobackTOcell()
Range("startcell").Select
End Sub
Sub memocell()
Set currentSelection = Application.ActiveCell
Set currentSelection.Name = "startcell"
End Sub

"Gord Dibben" wrote:

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.



--

Dave Peterson