¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¦^´_ 1# Genie
¤ñ¸û°ò¦ªº¼gªk- Sub oag()
- Range("g2:az20000").Clear '¦¹¦æ¥i§R°£ ¥Dn¬O¥Î¨Ó²M°£¦h¾l«½Æªº
- For uua = 1 To 3
- For uub = 4 To 6
- For uud = 2 To Range("a2").CurrentRegion.Rows.Count
- Select Case uua
- Case 1
- If Cells(uud, 1) = uua Then Cells(uud, uua + 22) = Cells(uud, 3)
- Select Case uub
- Case uub
- If Cells(uud, 1) = uua And Cells(uud, 2) = uub Then Cells(uud, uua + 21 + uub) = Cells(uud, 3)
- End Select
-
- Case 2
- If Cells(uud, 1) = uua Then Cells(uud, uua + 22) = Cells(uud, 3)
- Select Case uub
- Case uub
- If Cells(uud, 1) = uua And Cells(uud, 2) = uub Then Cells(uud, uua + 23 + uub) = Cells(uud, 3)
- End Select
- Case 3
- If Cells(uud, 1) = uua Then Cells(uud, uua + 22) = Cells(uud, 3)
- Select Case uub
- Case uub
- If Cells(uud, 1) = uua And Cells(uud, 2) = uub Then Cells(uud, uua + 25 + uub) = Cells(uud, 3)
- End Select
- End Select
- Next
- Next
- Next
- For aaa = 1 To Range("a2").CurrentRegion.Rows.Count
- For uus = 23 To 34
- For uuk = 2 To Range("a2").CurrentRegion.Rows.Count
- If Cells(2, uus) = "" Then
- Cells(2, uus).Select
- Selection.Delete Shift:=xlUp
- End If
- Next
- Next
- Next
- End Sub
½Æ»s¥N½X |
|