Fernando,
The code I proveded is a worksheet_change event and therefore the
contents of A1 would have to be changed from whatever the current value
is for the macro to be triggered (ie. just hitting return won't jump
you to B10).

If you really want to restrict the user to certian cells for data entry
then Bernie's suggestion may be the way to go.

HTH


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=386474