tab order for multi-range selections
 

Sorry - I posted this to the wrong group (I think)

Is there any way to control this? For example, if I "Edit Go To
Special Data validation Same" and then tab thru the selected cells,
I might start at C5 and go from there to C6, C7, G5, G6, G7, C20, E5,
E6, E7, E20, I20, A5, A6, A7, I5, I6, I7, A20, and then back to C5. This
means that somewhere this selection is represented internally as
"C5:7,G5:7,C20,E5:7,E20,I20,A5:7,I5:7,A20"; is there any way I can
change that to something more logical, like
"A5:7,C5:7,E5:7,G5:7,I5:7,A20,C20,E20,I20"?

tab order for multi-range selections
 

Wow - more than a week without a single response - I must've really
stumped you folks! :)

Phil wrote:
Is there any way to control this? For example, if I "Edit Go To
Special Data validation Same" and then tab thru the selected
cells, I might start at C5 and go from there to C6, C7, G5, G6, G7,
C20, E5, E6, E7, E20, I20, A5, A6, A7, I5, I6, I7, A20, and then back
to C5. This means that somewhere this selection is represented
internally as "C5:7,G5:7,C20,E5:7,E20,I20,A5:7,I5:7,A20"; is there any
way I can change that to something more logical, like
"A5:7,C5:7,E5:7,G5:7,I5:7,A20,C20,E20,I20"?