Sub aa()
Dim arr(), k '定义arr()
m = Range("A65536").End(xlUp).Row
For i = 1 To m
j = Cells(i, Columns.Count).End(xlToLeft).Column
k = k + 1
ReDim Preserve arr(1 To k)
If Cells(i, 1) <> "" Then
arr(k) = j '将变量j的值赋值给数组arr
End If
Next
Sheet2.Cells(1, 1).Resize(UBound(arr)) = Application.Transpose(arr) '在最后写入单元格
End Sub