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
Print macro won't work 3
Copy formula help 2
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Merge Append all sheet 1
Merge Append all sheet into 1 1
Data Entry - Write to next cell & next blank line 0

Top