how do i move the cursor from the end of a row to the beginning of the next
row after pressing ENTER

Hi, write a VBA code that does the following,
1. Check if the current cell is the last cell in the current row
2. If so, then set focus on the first cell of next row and activate it
I hope the above should help you.

"Tedebare" wrote:

how do i move the cursor from the end of a row to the beginning of the next
row after pressing ENTER

Start in A1 and Tab your way across the row as you enter your data.

When you get to the last data cell in that row, hit ENTER key to go back to
column A, next row down.

With this method, you will always go back to starting column one row down.

i.e. if you start in column C and Tab across, hitting ENTER key will move you
back to column C.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 08:21:19 -0700, Madhan
wrote:

Hi, write a VBA code that does the following,
1. Check if the current cell is the last cell in the current row
2. If so, then set focus on the first cell of next row and activate it
I hope the above should help you.

"Tedebare" wrote:

how do i move the cursor from the end of a row to the beginning of the next
row after pressing ENTER