|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- ra = 0
- rb = 0
- arr = ActiveSheet.UsedRange.Offset(1)
- brr = ActiveSheet.UsedRange.Offset(1)
- For j = 1 To UBound(arr) - 1
- If Val(arr(j, 4)) < 2 Then
- rb = rb + 1
- For i = 1 To UBound(arr, 2)
- brr(rb, i) = arr(j, i)
- Next i
- If Val(arr(j, 4)) = 0 Then
- ra = ra + 1
- For i = 1 To UBound(arr, 2)
- arr(ra, i) = arr(j, i)
- Next i
- End If
- End If
- Next j
- If ra > 0 Then Sheets(2).[a1].Resize(ra, UBound(arr, 2)) = arr
- If rb > 0 Then Sheets(3).[a1].Resize(rb, UBound(brr, 2)) = brr
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|