|
- Sub test()
- Dim arr, x%, y%, brr(), s%, num%, lrow%, lcol%
- arr = Sheet1.Range("a1").CurrentRegion
- Sheet2.Cells.ClearContents
- lrow = UBound(arr): lcol = UBound(arr, 2)
- ReDim brr(1 To lrow, 1 To lcol)
- For x = 2 To lrow
- num = CLng(arr(x, 1)) - CLng(arr(x, 3))
- If num > -2 And num < 4 Then
- s = s + 1
- For y = 1 To lcol
- brr(s, y) = arr(x, y)
- Next
- End If
- Next
- Sheet2.[a2].Resize(s, y) = brr
- Rows("1:1").Copy Sheet2.[a1]
- MsgBox "完毕"
- End Sub
-
复制代码 |
|