If you are on Excel 2007 or above, run this code from a sub-routine, or immediate window
ORCode:Application.MoveAfterReturnDirection = xlToRight
Go to Excel Options >> Advanced >> Editing Options >> Ensure the 'After pressing Enter, move selection' is checked >> Select 'Right' in the drop-down below.




Reply With Quote
Bookmarks