cell reference
 

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)

cell reference
 

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)

cell reference
 

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)