|
<p>你把以下代码复制到“手动成绩排序”表的VBA编辑器中的代码窗口后存盘即可自动排序。</p><p>rivate Sub Worksheet_Activate()<br/>Application.ScreenUpdating = False<br/> Range("A2:D1150").Select<br/> ActiveWindow.ScrollRow = 1121<br/> ActiveWindow.ScrollRow = 1107<br/> ActiveWindow.ScrollRow = 1099<br/> ActiveWindow.ScrollRow = 1092<br/> ActiveWindow.ScrollRow = 1082<br/> ActiveWindow.ScrollRow = 1070<br/> ActiveWindow.ScrollRow = 1056<br/> ActiveWindow.ScrollRow = 1037<br/> ActiveWindow.ScrollRow = 1019<br/> ActiveWindow.ScrollRow = 1001<br/> ActiveWindow.ScrollRow = 982<br/> ActiveWindow.ScrollRow = 966<br/> ActiveWindow.ScrollRow = 943<br/> ActiveWindow.ScrollRow = 925<br/> ActiveWindow.ScrollRow = 907<br/> ActiveWindow.ScrollRow = 888<br/> ActiveWindow.ScrollRow = 870<br/> ActiveWindow.ScrollRow = 852<br/> ActiveWindow.ScrollRow = 833<br/> ActiveWindow.ScrollRow = 817<br/> ActiveWindow.ScrollRow = 799<br/> ActiveWindow.ScrollRow = 780<br/> ActiveWindow.ScrollRow = 762<br/> ActiveWindow.ScrollRow = 739<br/> ActiveWindow.ScrollRow = 717<br/> ActiveWindow.ScrollRow = 695<br/> ActiveWindow.ScrollRow = 672<br/> ActiveWindow.ScrollRow = 650<br/> ActiveWindow.ScrollRow = 627<br/> ActiveWindow.ScrollRow = 609<br/> ActiveWindow.ScrollRow = 591<br/> ActiveWindow.ScrollRow = 568<br/> ActiveWindow.ScrollRow = 550<br/> ActiveWindow.ScrollRow = 527<br/> ActiveWindow.ScrollRow = 511<br/> ActiveWindow.ScrollRow = 491<br/> ActiveWindow.ScrollRow = 474<br/> ActiveWindow.ScrollRow = 456<br/> ActiveWindow.ScrollRow = 442<br/> ActiveWindow.ScrollRow = 427<br/> ActiveWindow.ScrollRow = 415<br/> ActiveWindow.ScrollRow = 405<br/> ActiveWindow.ScrollRow = 395<br/> ActiveWindow.ScrollRow = 384<br/> ActiveWindow.ScrollRow = 374<br/> ActiveWindow.ScrollRow = 364<br/> ActiveWindow.ScrollRow = 354<br/> ActiveWindow.ScrollRow = 344<br/> ActiveWindow.ScrollRow = 338<br/> ActiveWindow.ScrollRow = 336<br/> ActiveWindow.ScrollRow = 327<br/> ActiveWindow.ScrollRow = 317<br/> ActiveWindow.ScrollRow = 307<br/> ActiveWindow.ScrollRow = 297<br/> ActiveWindow.ScrollRow = 289<br/> ActiveWindow.ScrollRow = 280<br/> ActiveWindow.ScrollRow = 270<br/> ActiveWindow.ScrollRow = 260<br/> ActiveWindow.ScrollRow = 250<br/> ActiveWindow.ScrollRow = 236<br/> ActiveWindow.ScrollRow = 223<br/> ActiveWindow.ScrollRow = 209<br/> ActiveWindow.ScrollRow = 195<br/> ActiveWindow.ScrollRow = 180<br/> ActiveWindow.ScrollRow = 172<br/> ActiveWindow.ScrollRow = 158<br/> ActiveWindow.ScrollRow = 144<br/> ActiveWindow.ScrollRow = 132<br/> ActiveWindow.ScrollRow = 121<br/> ActiveWindow.ScrollRow = 111<br/> ActiveWindow.ScrollRow = 107<br/> ActiveWindow.ScrollRow = 97<br/> ActiveWindow.ScrollRow = 89<br/> ActiveWindow.ScrollRow = 83<br/> ActiveWindow.ScrollRow = 74<br/> ActiveWindow.ScrollRow = 68<br/> ActiveWindow.ScrollRow = 60<br/> ActiveWindow.ScrollRow = 56<br/> ActiveWindow.ScrollRow = 52<br/> ActiveWindow.ScrollRow = 44<br/> ActiveWindow.ScrollRow = 36<br/> ActiveWindow.ScrollRow = 25<br/> ActiveWindow.ScrollRow = 11<br/> ActiveWindow.ScrollRow = 3<br/> Selection.Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlGuess, _<br/> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _<br/> :=xlPinYin, DataOption1:=xlSortNormal<br/> Range("G2:J648").Select<br/> ActiveWindow.ScrollRow = 619<br/> ActiveWindow.ScrollRow = 615<br/> ActiveWindow.ScrollRow = 612<br/> ActiveWindow.ScrollRow = 610<br/> ActiveWindow.ScrollRow = 604<br/> ActiveWindow.ScrollRow = 598<br/> ActiveWindow.ScrollRow = 593<br/> ActiveWindow.ScrollRow = 589<br/> ActiveWindow.ScrollRow = 583<br/> ActiveWindow.ScrollRow = 573<br/> ActiveWindow.ScrollRow = 563<br/> ActiveWindow.ScrollRow = 550<br/> ActiveWindow.ScrollRow = 534<br/> ActiveWindow.ScrollRow = 521<br/> ActiveWindow.ScrollRow = 505<br/> ActiveWindow.ScrollRow = 491<br/> ActiveWindow.ScrollRow = 477<br/> ActiveWindow.ScrollRow = 464<br/> ActiveWindow.ScrollRow = 451<br/> ActiveWindow.ScrollRow = 439<br/> ActiveWindow.ScrollRow = 424<br/> ActiveWindow.ScrollRow = 409<br/> ActiveWindow.ScrollRow = 394<br/> ActiveWindow.ScrollRow = 380<br/> ActiveWindow.ScrollRow = 365<br/> ActiveWindow.ScrollRow = 350<br/> ActiveWindow.ScrollRow = 338<br/> ActiveWindow.ScrollRow = 325<br/> ActiveWindow.ScrollRow = 308<br/> ActiveWindow.ScrollRow = 290<br/> ActiveWindow.ScrollRow = 271<br/> ActiveWindow.ScrollRow = 253<br/> ActiveWindow.ScrollRow = 238<br/> ActiveWindow.ScrollRow = 222<br/> ActiveWindow.ScrollRow = 206<br/> ActiveWindow.ScrollRow = 191<br/> ActiveWindow.ScrollRow = 177<br/> ActiveWindow.ScrollRow = 160<br/> ActiveWindow.ScrollRow = 149<br/> ActiveWindow.ScrollRow = 136<br/> ActiveWindow.ScrollRow = 125<br/> ActiveWindow.ScrollRow = 112<br/> ActiveWindow.ScrollRow = 104<br/> ActiveWindow.ScrollRow = 98<br/> ActiveWindow.ScrollRow = 92<br/> ActiveWindow.ScrollRow = 87<br/> ActiveWindow.ScrollRow = 83<br/> ActiveWindow.ScrollRow = 79<br/> ActiveWindow.ScrollRow = 75<br/> ActiveWindow.ScrollRow = 71<br/> ActiveWindow.ScrollRow = 67<br/> ActiveWindow.ScrollRow = 63<br/> ActiveWindow.ScrollRow = 59<br/> ActiveWindow.ScrollRow = 55<br/> ActiveWindow.ScrollRow = 51<br/> ActiveWindow.ScrollRow = 49<br/> ActiveWindow.ScrollRow = 44<br/> ActiveWindow.ScrollRow = 41<br/> ActiveWindow.ScrollRow = 36<br/> ActiveWindow.ScrollRow = 32<br/> ActiveWindow.ScrollRow = 28<br/> ActiveWindow.ScrollRow = 25<br/> ActiveWindow.ScrollRow = 17<br/> ActiveWindow.ScrollRow = 12<br/> ActiveWindow.ScrollRow = 10<br/> ActiveWindow.ScrollRow = 9<br/> ActiveWindow.ScrollRow = 6<br/> ActiveWindow.ScrollRow = 5<br/> ActiveWindow.ScrollRow = 4<br/> ActiveWindow.ScrollRow = 3<br/> Selection.Sort Key1:=Range("G3"), Order1:=xlAscending, Header:=xlGuess, _<br/> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _<br/> :=xlPinYin, DataOption1:=xlSortNormal<br/> Range("F1").Select<br/> ActiveWindow.SmallScroll Down:=-18<br/> Range("F1").Select<br/> ActiveCell.FormulaR1C1 = "已排序"<br/> Range("F1").Select<br/> Application.ScreenUpdating = True<br/>End Sub<br/></p><p></p> |
|