Sub demo()
Dim ar, br(), i, n
ar = Sheet1.Range("a1:a" & [a1048576].End(3).Row)
For i = 1 To UBound(ar)
If Right(ar(i, 1), 1) <> "-" Then
n = n + 1
ReDim Preserve br(1 To UBound(ar), 1 To 1)
br(n, 1) = ar(i, 1)
End If
Next
Columns("k").Clear
Range("k1").Resize(n, 1) = br
End Sub
我也练练