G Guest Mar 18, 2007 #1 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
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 Guest Mar 18, 2007 #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.
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 Mar 18, 2007 #3 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
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
