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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IN EXCEL. HOW TO PRINT ONLY ROWS THAT HAVE A VALU IN COLUM A 2
Lost/help not finding the correct terminology questions for help 2
Different colum widths for same colum in different areas of worksh 6
Combine three InputBoxes into one? 7
Want "$0", not "VALUE" to print 8
link colums 1
excel If I put 1 in colum b I want it to = $30.00 in colum c same 2
Excel to Excel Import and Data Mapping 1

Back
Top