marco to change cursor movement

[ed.ayers315]

Hello forum,

Looking for a macro to move down when enter is pressed while in column a or c and move right when in any other column.

Thanks

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Column
    Case 1, 3
        Application.MoveAfterReturnDirection = xlToRight
    Case Else
        Application.MoveAfterReturnDirection = xlDown
End Select
End Sub

 

[ed.ayers315]

Solved,

Peter, Thanks a bunch!!