ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   tab order for multi-range selections (https://www.excelbanter.com/excel-worksheet-functions/238494-tab-order-multi-range-selections.html)

Phil

tab order for multi-range selections
 
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"?

Phil

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



All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com