Negotiating Cells in Specific Order
I have an array of unlocked cells that constitue a range:
e.g. d7 h7 d8 h8 d9 h9 h10 c12 f12
I would like the TAB and ENT keys to always negotiate the range in an
explicit way.
e.g. in the order: d7 d8 d9 c12 f12 h7 h8 h9 h10
Is there a relatively elegant way of doing this?
I'm building up a monster of a module to take care of this
(involving Worksheet_SelectionChange procedure
Case statements and
keeping track of the "previous" selection.)
My intuition tells me I'm missing something.... Any help?
|