写错了一个字母。
Sub TEST()
Sheets("查看个股资金变动").UsedRange.Offset(2, 0).ClearContents
With Sheets("个股实时资金流向排行")
ARR = .UsedRange
For I = 8 To Range("H65536").End(3).Row
For J = 3 To UBound(ARR)
If ARR(J, 2) = Cells(I, "H") Then
S = S + 1
.Rows(
J).Copy Sheets("查看个股资金变动").Cells(S + 2, 1)
End If
Next
Next
End With
Sheets("查看个股资金变动").Select
End Sub