- ©«¤l
- 8
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2013-9-9
- ³Ì«áµn¿ý
- 2015-7-26
|
½Ð¸Õ¸Õ¬Ý¤U¦Cµ{¦¡¡G- Sub delRows()
- Dim i&, j&, x%, y%
- j = Range("a1").End(xlDown).Row
- MsgBox "j = " & j
- j = j / 42
- MsgBox "New j = " & j
- x = 1
- y = 16
- For i = 1 To j
- If i = 1 Then
- Rows(x & ":" & y).Select
- Selection.Delete Shift:=xlUp
- Else
- x = x + 42
- y = y + 42
- Rows(x & ":" & y).Select
- Selection.Delete Shift:=xlUp
- End If
- Next i
- End Sub
½Æ»s¥N½X |
|