As ALWAYS, post your code for comments.
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
If Target.Address < Range("g1").Address Then Exit Sub
Range(Target).Select
MsgBox "Went to target address"
Application.Goto Range(Target.Address)
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Rohit" wrote in message
...
hi,
i have formula in cell A5 and when i double click, it takes me to the
respective cell. my question how can i go back to that cell (A5)