Hsieh

¦^´_ 1# ©P¤j°¶
Ãö³¬¨Æ¥óµ{§ÇIJµo

1. Sub ²M°£±×½u()
   
2. '
   
3. ' ²M°£±×½u Macro
   
4. ' shchao ¦b 2010/11/15 ¿ý»sªº¥¨¶°
   
5. '
   
6. 
   
7. '
   
8. Application.EnableEvents = False
   
9.     Range("B15:K34").Select
   
10.     Selection.ClearContents
    
11.     Selection.Borders(xlDiagonalDown).LineStyle = xlNone
    
12.     Selection.Borders(xlDiagonalUp).LineStyle = xlNone
    
13.     With Selection.Borders(xlEdgeLeft)
    
14.         .LineStyle = xlDouble
    
15.         .Weight = xlThick
    
16.         .ColorIndex = xlAutomatic
    
17.     End With
    
18.     With Selection.Borders(xlEdgeTop)
    
19.         .LineStyle = xlDouble
    
20.         .Weight = xlThick
    
21.         .ColorIndex = xlAutomatic
    
22.     End With
    
23.     With Selection.Borders(xlEdgeBottom)
    
24.         .LineStyle = xlContinuous
    
25.         .Weight = xlThin
    
26.         .ColorIndex = 15
    
27.     End With
    
28.     With Selection.Borders(xlEdgeRight)
    
29.         .LineStyle = xlDouble
    
30.         .Weight = xlThick
    
31.         .ColorIndex = xlAutomatic
    
32.     End With
    
33.     With Selection.Borders(xlInsideVertical)
    
34.         .LineStyle = xlContinuous
    
35.         .Weight = xlMedium
    
36.         .ColorIndex = 15
    
37.     End With
    
38.     With Selection.Borders(xlInsideHorizontal)
    
39.         .LineStyle = xlContinuous
    
40.         .Weight = xlThin
    
41.         .ColorIndex = 15
    
42.     End With
    
43.     Range("E8:F8").Select
    
44.     Application.EnableEvents = True
    
45. End Sub

½Æ»s¥N½X

Hsieh

¦^´_ 4# ©P¤j°¶


    §Æ±æ¦b³o2­Ó¦^ÂФ¤±z¯à¤F¸Ñ´X­Ó­«ÂI
1¡Bµ{¦¡½X¤¤ªºSELECT·|IJµo¨Æ¥óµ{§Çªº¸Ñ¨M¤èªk
2¡B¿ý»s¥¨¶°«áÀ³¥h¸ÑŪµ{¦¡½Xªº·N¸q¡A¤~¯à¥h¿¾¦sµ×´îµuµ{¦¡½X¡A©ö©ó¤é«á­×¥¿