selection change macro to go down 1 cell

[Billy]

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

 

[Rick Rothstein]

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

 

[Billy]

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 = 1Then
    Target.Offset(1).Select
  End If
End Sub

--
Rick (MVP - Excel)







- Show quoted text -

Rick,

Thanks! Got this to working just fine!
Again, many thanks,

Tonso