Enter data and press enter to move to specific cell
 

after enering data how can I press enter to move to a specific cell?

Enter data and press enter to move to specific cell
 

Do you want a programming solution or other?

You can protect the sheet with the cells to move to unlocked and disallow
selection of locked cells.

You can define a named range and follow the sequence of the cells in the named
range.

See Bob Phillips' site for named range method.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You can use Case Select code to move from one cell to another as you press enter
key.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 19:11:00 -0800, Programing problem
wrote:

after enering data how can I press enter to move to a specific cell?

Enter data and press enter to move to specific cell
 

If the sheet is protected and selection of locked cells is not allowed, the
next unlocked cell determined by the setting of ToolsOptionsEditMove
selection after Enter will be selected.

If you want to go to some other specific cell, try the method in the recent,
previous thread "how do I put my unprotected cells in order to answer
they're mixed" in this NG.

NickHK

"Programing problem" wrote in
message ...
after enering data how can I press enter to move to a specific cell?