修改后的代码是 Sub aa() Dim rng As Range Dim arr Dim a As String Dim i As Long arr = Sheet1.Range("A4:C" & Sheet1.Range("A65536").End(xlUp).Row) a = Sheet2.Range("A2") Sheet2.Range("A4:AL65536").Delete For i = 1 To UBound(arr, 1) arr(i, 1) = arr(i, 1) & arr(i, 2) & arr(i, 3) Next i For i = 1 To UBound(arr, 1) If InStr(arr(i, 1), a) Then If rng Is Nothing Then Set rng = Sheet1.Rows(i + 3) Else Set rng = Union(rng, Sheet1.Rows(i + 3)) End If End If Next i If Not rng Is Nothing Then rng.Copy Destination:=Sheet2.Range("A4") End If End Sub
|