|
- Sub aaa()
- Dim i&, rng As Range, rng1 As Range
- For i = 4 To [a65536].End(3).Row
- If Cells(i, 2) > 0 Then
- If rng Is Nothing Then Set rng = Cells(i, 1).Resize(, 2) Else Set rng = Union(rng, Cells(i, 1).Resize(, 2))
- ElseIf Cells(i, 2) < 0 Then
- If rng1 Is Nothing Then Set rng1 = Cells(i, 1).Resize(, 2) Else Set rng1 = Union(rng1, Cells(i, 1).Resize(, 2))
- End If
- Next i
- rng.Copy Sheets("奖励表").[m65536].End(3).Offset(1)
- rng1.Copy Sheets("考核表").[m65536].End(3).Offset(1)
- End Sub
复制代码 |
|