Returning to a column

  • Thread starter Thread starter Gadgetman
  • Start date Start date
G

Gadgetman

Could someone please advise me how I can set my Worksheet to solve thi
problem.
After entering data in a row, e.g. Line 10, Column H, I need to hi
RETURN for the next cell to be used, which will be in the next row i
column A. e.g. Line 11, Column A and so on.

Thank
 
Here is one I use. After entering I use the right arrow. When the cursor
hits col 8 it goes to the next row 6 cells to the left.
right click sheet tab>view code>copy/paste this>modify to suit>save

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Row > 5 And Target.Column = 8 Then ActiveCell.Offset(1, -6).Select
End Sub
 
Gadget

Two methods.......

1. Unlock columns A through H then protect the worksheet. Use the TAB key to
move across the columns. When you reach H and hit TAB you will go back to A
and down one row.

2. Start entering data in column A(or any column) and TAB to next cell
across. When you reach H hit <ENTER> key to return to A(or start column) one
row down. No need for sheet protection with this method.

Gord Dibben Excel MVP
 
Option 2 would assume that you have your "move after entry" checked and down
selected.
 
Back
Top