- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-6-26 19:59 ½s¿è
¦^´_ 3# myleoyes
Leov11 ¬O³sÄòªº½d³ò Leov11-1 ¤¤¶¡¦³ÁôÂ꺽d³ò¬O¤£¦Pªº- Sub Ex()
- Dim R, A, C, Rng As Range, II%
- If ActiveCell.Column >= 3 And ActiveCell.Column <= 15 Then
- If ActiveCell.Column Mod 2 > 0 Then
- R = (ActiveCell.Row - 5) Mod 12
- If R >= 0 And R <= 11 Then
- ActiveCell.Copy Cells(2, ActiveCell.Column)
- Application.EnableEvents = False
- Set Rng = ActiveCell.EntireColumn.SpecialCells(xlCellTypeVisible)
- For Each C In Rng.Areas
- For Each A In C.Cells
- If A.Row = ActiveCell.Row Then II = 1
- If II > 0 Then II = II + 1
- If II = 14 Then
- Cells(2, ActiveCell.Column + 1) = ActiveCell.Offset(, 1) - A.Offset(, 1)
- Application.EnableEvents = True
- Exit Sub
- End If
- Next
- Next
- End If
- End If
- End If
- End Sub
½Æ»s¥N½X |
|