Cursor auto move from one cell to another-How can I have my cursor automatically move

How can I have my cursor automatically move from cell C9 to cell A14 after hitting the enter key in cell C9? (note, there may be data entered or else it may be left blank)

Thanks all,

mikeburg

One way is to use a "named range".

Check out this old post:

http://tinyurl.com/39vzv

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"mikeburg" <mikeburg.1udvaa_1125079504.6054@excelforum-nospam.com> wrote in
message news:mikeburg.1udvaa_1125079504.6054@excelforum-nospam.com...
>
> How can I have my cursor automatically move from cell C9 to cell A14
> after hitting the enter key in cell C9? (note, there may be data
> entered or else it may be left blank)
>
> Thanks all,
>
> mikeburg
>
>
> --
> mikeburg
> ------------------------------------------------------------------------
> mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
> View this thread: http://www.excelforum.com/showthread...hreadid=399546
>