Look at the BeforeDoubleClick event
Right click on the sheet tab and select view code. Something like this:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel
As Boolean)
If not Intersect(Target,"Range("A1:A8","F1:F8")) is nothing then
Target.offset(0,3.Select
End if
End Sub
See Chip Pearson's page on events if you are not familiar
http://www.cpearson.com/excel/events.htm
--
Regards,
Tom Ogilvy
"rayjay" wrote in message
...
i'm trying to program in excel and have one cell i dble click on go to
another cell. is this possible. There are around sixteen different cells
to
choose from.