cell reference

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

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.
 
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
 
Back
Top