tab order for multi-range selections

P

Phil

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"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
proper writing of a formula 8
Copy formula help 2
Print macro won't work 3
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Sudoku array-problem 3
Formula Help Needed (Sum and If Then) 1
Creating a function to randomize a list of alphanumeric entries in an array 5

Top