心灵感应
幼苗
共回答了13个问题采纳率:84.6% 举报
Sub test()
Dim arr
Dim r As Long,c As Integer,n As Long
arr = ActiveSheet.UsedRange.Value
Sheets.Add
For r = 1 To UBound(arr)
For c = 1 To UBound(arr,2)
n = n + 1
Cells(n,1) = arr(r,c)
Next
Next
End Su
1年前
追问
10
焦作55
举报
请问n就是原数据的列数么?按第一张图就是H?
举报
心灵感应
如果你固定8列,将UBound(arr, 2)改为8