|
问题可能出现在你的名表上.
Sub test()
Application.DisplayAlerts = False: Application.ScreenUpdating = False
Dim sht, arr, i, n, j, brr()
Set sht = Sheets("sheet0")
arr = sht.[a1].CurrentRegion
For i = 1 To UBound(arr)
If arr(i, 3) <> 0 Then
n = n + 1
ReDim Preserve brr(1 To 3, 1 To n)
For j = 1 To 3
brr(j, n) = arr(i, j)
Next j
End If
Next i
sht.Range("a1:c" & UBound(arr)).Clear
sht.[a1].Resize(UBound(brr, 2), UBound(brr)) = Application.Transpose(brr)
MsgBox "OK,完成!!!", 48, "温馨提示……"
Application.DisplayAlerts = True: Application.ScreenUpdating = True
End Sub
|
评分
-
1
查看全部评分
-
|