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

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

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

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.
--
Gary''s Student
gsnu200711


"Greg" wrote:

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

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

Greg

Make sure your ToolsOptionsEdit "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



On Sun, 18 Mar 2007 04:00:03 -0700, Greg wrote:

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