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

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

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