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)

Hit the F5 key / enter A5 / hit OK.

If my comments have helped please hit Yes.

Thanks.

"Rohit" wrote:

> 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)

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
(E-Mail Removed)
"Rohit" <(E-Mail Removed)> wrote in message
newsE0F631C-39C1-479D-A0E6-(E-Mail Removed)...
> 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)