点击文件名下载附件
试试这个代码
Sub 筛选()
Dim Ro As Long
Dim i As Long
Dim st As Long
Dim Rng(1 To 255) As Range
[I3].Resize([A65536].End(xlUp).Row - 3, 2).Clear
For Ro = 3 To [A65536].End(xlUp).Row
If Cells(Ro, 4) = "往来" Then
i = i + 1
Set Rng(i) = Range("A" & Ro).Resize(1, 2)
End If
Next Ro
For st = 2 To i
Set Rng(1) = Union(Rng(1), Rng(st))
Next st
Rng(1).Copy Sheets("报表项目").[I3]
End Sub
点击文件名下载附件
试试这个代码
Sub 筛选()
Dim Ro As Long
Dim i As Long
Dim st As Long
Dim Rng(1 To 255) As Range
[I3].Resize([A65536].End(xlUp).Row - 3, 2).Clear
For Ro = 3 To [A65536].End(xlUp).Row
If Cells(Ro, 4) = "往来" Then
i = i + 1
Set Rng(i) = Range("A" & Ro).Resize(1, 2)
End If
Next Ro
For st = 2 To i
Set Rng(1) = Union(Rng(1), Rng(st))
Next st
Rng(1).Copy Sheets("报表项目").[I3]
End Sub