Automatically Making cell Active

I have 5 columns namely Col A, Col B, Col C, Col D, and Col E and 50 rows in my sheets.
I make measurements for each column for over each row and then move to the new row and so on.

I am writing a small VBA script such that every time I enter a data in Col E I automatically move my cursor 1 row down and back to Col A.

However everytime the cursor moves two rows down.

Can any tell me what I am doing wrong?

My line of code is:

Please Login or Register  to view this content.

I suspect you have Excel set to automatically move one cell down after you press ENTER.
Either turn that feature off...or:
Try this code:

Please Login or Register  to view this content.

Is that something you can work with?

You might need this in the Sheet Module for the sheet you want to control.

Please Login or Register  to view this content.

Right-click on the Sheet tab and select View code.

Paste all of the above in the resultant VBA pane.

Hope this helps

Thanks guys..
All your comments really helped... thanks for posting your replies.