On Wednesday, August 8, 2012 11:07:23 AM UTC-5, magmike wrote:
Is there a way to override Excel's desire to go to the cell it thinks I want it to go to, and using VB force Excel to send the selection to the 2nd Column of the next line when the ENTER key is used? magmike

Thanks for the idea James. Unfortunately, this works too well. It is predicated on a change being made, and not the use of the Enter key. If I make a change and hit tab to go to the cell in the column to the right of my current selection, I instead get sent to the next line before I am ready. I am also hopeful to find a way to do this that would send me to Column B of the next line after hitting ENTER, even if a change was not made.

Anyother ideas?

magmike