| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
