|
- Private Sub 删除指定行_Click()
- Dim ar, br, i As Long, j As Long, s As Long
- ar = Sheets("4").UsedRange
- ReDim br(1 To UBound(ar), 1 To UBound(ar, 2))
- For i = 1 To UBound(ar)
- If i Mod 110 > 10 Or i Mod 110 = 0 Then
- s = s + 1
- For j = 1 To UBound(ar, 2)
- br(s, j) = ar(i, j)
- Next
- End If
- Next
- Sheets("4").UsedRange.ClearContents
- Sheets("4").Range("a1").Resize(s, UBound(br, 2)) = br
- End Sub
复制代码 附件楼下
|
|