View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
Phil Phil is offline
external usenet poster
 
Posts: 7
Default 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"?