right click sheet tabview codeinsert this. Now if b100 is typed into the
active cell and you double click you will go there.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Range(Target).Select
End Sub


--
Don Guillett
SalesAid Software

"chbelair" wrote in message
...
For example, if cell a1 = b100, I would like to be able to double click on
A1
and automatically go to cell b100.