第1个回答 2022-01-05
Option Explicit
Sub test()
Dim i As Integer
Dim rng As Range
Dim arr() As Variant
'假设你的数据在表1
Sheets(1).Select
'假设你的表1数据全为姓名,如果有其它数据,你需要说明姓名在哪一行或者哪一列
For Each rng In ActiveSheet.UsedRange
If Len(rng.Value) > 3 Then
i = i + 1
ReDim Preserve arr(1 To i)
arr(i) = rng.Value
End If
Next
'假设你要粘贴到表2
Sheets(2).Select
'假设你要粘贴到A列
Range("A1").Resize(i) = arr
End Sub