View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default selection change macro to go down 1 cell

Give this a try...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5 And Target.Row 12 And Target.Row Mod 2 = 1 Then
Target.Offset(1).Select
End If
End Sub

--
Rick (MVP - Excel)



"Billy" wrote in message
...
i need a macro that will move the cursor down 1 when certain cells are
slected.
the cells are e13, e15, e17, e19, etc. when any of these r selected, i
would lie the cursor to go to e14, or e 16, or e 18, etc, so the
slection change is down 1.

thanks...
Tonso