可修改为:
Sub TEST()
Range("B2:W65500").ClearContents
ARR = Sheets(1).Range("A2:A" & Sheets(1).Range("A65536").End(3).Row)
BRR = Sheets(2).Range("A2:A" & Sheets(2).Range("A65536").End(3).Row)
If IsArray(ARR) Then
For I = 1 To UBound(ARR)
For J = 1 To UBound(BRR)
If ARR(I, 1) = BRR(J, 1) Then
AD = Sheets(1).Cells(I + 1, 255).End(1)(1, 2).Address
Sheets(2).Range("B" & J + 1 & ":C" & J + 1).Copy Sheets(1).Range(AD)
End If
Next
Next
Else
For J = 1 To UBound(BRR)
If ARR = BRR(J, 1) Then
AD = Sheets(1).Cells(2, 255).End(1)(1, 2).Address
Sheets(2).Range("B" & J + 1 & ":C" & J + 1).Copy Sheets(1).Range(AD)
End If
Next
End If
End Sub