active cell's movement from up/down/left/right adjacent to other select cells

[Dan]

Hi folks,

What I'm looking for is a way to have the active cell's
movement go someplace specific instead of adjacent.

For example--

If i enter 'xyz' into cell A1 and then i want to
enter 'yhz' into cell D8.

How do I make the cursor go to D8 after i hit enter in A1?

Thanks in advance for the help!

 

[Ragdyer]

One way to explicitly control the exact "next cell of focus" selection, is
to select the cells in the desired order of travel, and then preserve this
ordered movement by creating a named range.

This old post describes the steps that can be taken to create such a "named
range".

http://tinyurl.com/39vzv


--

HTH,

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