selection change macro to go down 1 cell
 

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

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

selection change macro to go down 1 cell
 

On Apr 24, 2:44*pm, "Rick Rothstein"
wrote:
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- Hide quoted text -

- Show quoted text -

Rick,

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

Tonso