|
Public Sub master2()
Dim vaSdata As Variant
Dim vaDdata() As Variant
Dim lMaxrow As Long
Dim i As Long, n As Long
Dim sRng As String
vaSdata = Sheets("原始数据").UsedRange
lMaxrow = UBound(vaSdata)
i = 1
ReDim vaDdata(1 To lMaxrow, 1 To 2)
For n = 1 To lMaxrow
If vaSdata(n, 1) <> "" And vaSdata(n, 2) <> "" Then
vaDdata(i, 1) = vaSdata(n, 1)
vaDdata(i, 2) = vaSdata(n, 2)
i = i + 1
End If
Next
sRng = "a1" & ":" & "b" & lMaxrow
Sheets("整理后").Range(sRng) = vaDdata
End Sub
数组做法。
grf1973也做了呀,让我学习一下。 |
|