MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro for" moving selection after Enter" to another cell.


Posted by Bob C on December 11, 2001 11:34 AM

How can I set up my sheet so that after I enter the contents in G445 the I automatically go to cell A446.


Posted by Ben H on December 11, 2001 11:43 AM

I'm not sure if you want to do this manually or programmatically...

Manually: Go to Tools...Options...Edit...Check the box "Move Selection After Enter"

Programmatically: Application.MoveAfterReturn = True

Posted by Bob C on December 11, 2001 11:46 AM

Re: Macro for

I would like to do it programmatically.

Posted by Ben H on December 11, 2001 1:27 PM

Re: Macro for

Application.MoveAfterReturn = True