- ©«¤l
- 84
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- offcie 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2024-2-17
|
[µo°Ý] ®Ö¨ú¤è¶ô ¦^¦s¸ê®Æ PART~2
¤j®v¦n
¦¹¥¨¶°¬°¬Y¤j®vÀ°¦£§¹¦¨¤§³Ç§@,·Q¦b§ï¦¨¹F¨ì¥H¤Uªº¥\¯à¬O§_¥iÀ°À°¦£,
1.º¥ý¦bSheet1 ©³¤U¿é¤J¸ê®Æ«á«ö¤U
¡½¥[¤u¤@ C25:= 1 ¡½¥[¤u¤@ C26:= 1 ¡½¥[¤u¤@ C27:= 1
2.SHEET2 §e²{µ²ªG¦p¤U ¶µ¦¸ L 13¥H¤U ¦Û°Ê²£¥Í
3.¦bSheet1 ©³«ö¤U
¡¼¥[¤u¤@ C25:= 0 ¡¼¥[¤u¤@ C26:= 0 ¡¼¥[¤u¤@ C27:= 0
4.SHEET2 §e²{µ²ªG¦p¤U ¶µ¦¸ L13:S27¥H¤U ²M°£¤º®e
Option Explicit
Sub check()
Dim K As String, M As Boolean, xRow As Integer, xi As Integer
With ActiveSheet.Shapes(Application.Caller)
With .TextFrame
K = .Characters.Text
If Left(K, 1) = "¡½" Then
.Characters.Text = "¡¼¥[¤u¤@"
M = False
Else
.Characters.Text = "¡½¥[¤u¤@"
M = True
End If
.Characters(1, Len(K) + 1).Font.Size = 10
.Characters(1, 1).Font.Size = 10
End With
.TopLeftCell.Offset(, 1) = M
.TopLeftCell.Offset(, 2) = IIf(CSng(M) = 0, 0, 1)
End With
Sheet2.UsedRange("L13:S27").ClearContents
xRow = 25
With ActiveSheet
Do While .Cells(xRow, "C") <> ""
If .Cells(xRow, "C") = 1 Then
xi = xi + 1
Sheet2.Rows(1).Copy Sheet2.Cells(Rows.Count, "A").End(xlUp).Offset(1)
With Sheet2.Cells(Rows.Count, "A").End(xlUp)
.Cells(1) = xi
.Cells(12, 14) = ActiveSheet.Cells(xRow, "F")
.Cells(12, 17) = ActiveSheet.Cells(xRow, "H")
.Cells(12, 18) = ActiveSheet.Cells(xRow, "J")
.Cells(12, 19) = ActiveSheet.Cells(xRow, "K")
End With
End If
xRow = xRow + 1
Loop
End With
End Sub
kai~20.rar (72.82 KB)
|
-
1
µû¤À¤H¼Æ
-
|