¨D°Ý­ì¦]¡G±Æ§Ç4­Ókey¥X²{Error, 3­Ókey ¨S°ÝÃD

198188

1. Letter = "G"
   
2. Worksheets("Backup").Range("A2:BB65536").sort Key1:=Range("D3"), Order1:=xlAscending, _
   
3.                          Key2:=Range("A3"), Order2:=xlAscending, Key3:=Range(letter & "3"), Order3:=xlAscending, Header:=xlYes
   
4. 
   
5. 
   
6. Worksheets("Backup").Range("A2:BB65536").sort Key1:=Range("D3"), Order1:=xlAscending, _
   
7.                          Key2:=Range("A3"), Order2:=xlAscending, Key3:=Range("B3"), Order3:=xlAscending, Key4:=Range(letter & "3"), Order4:=xlAscending, Header:=xlYes

½Æ»s¥N½X

¦b°µ±Æ§Ç®É¡A§Ú¨Ï¥Î4­Ókey ´N·|¥X²{Error, ¥u¬O3­ÓKey´N¨S°ÝÃD¡A½Ð°Ý¬O¤°麽­ì¦]

198188

¦^´_ 2# Andy2483

¤W­±ªº´N¬O¿ý»s¥¨¶°¦Z¡A§Û¨ìµ{¦¡内¡A¥i¬O¹B¦æ®É¥X²{¿ù»~¡C
µM«á§Ú§R¤FKEY4¦Z¡A´N¨S°ÝÃD¤F¡C