excel press enter to make active on 1st colum in new row

G

Greg

lets say I have 10 colums in a worksheet, when in colum 10 of row, i want to
automatically go to colum 1 of row 2
 
G

Gary''s Student

Enter the following in Worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("J:J"), Target) Is Nothing Then
Exit Sub
End If
Cells(Target.Row + 1, 1).Select
End Sub

After an entry is made in column 10, we move back to column 1 the next row
down.


REMEMBER: Worksheet code.
 
G

Gord Dibben

Greg

Make sure your Tools>Options>Edit "move selection after enter" is set for
"down".

Assume you start in A1.

Tab your way across to column J.

When leaving column J hit the ENTER key to go back to A2.


Gord Dibben MS Excel MVP
 
Top