|
- Sub test()
- Dim i%, j%, x%, y%, n%, l%
- With Sheets("3")
- Sheets("2").UsedRange.Copy .Range("a1") '复制源数据到表3
- x = .UsedRange.Columns.Count '列宽
- For i = 1 To .UsedRange.Rows.Count '循环数据源1至最后一行
- y = Application.Count(.Rows(i)) '统计每一行非空单元格
- If y > 3 Then '超过3个非空
- n = 0: l = 0: j = 0 'n非空位置,l删除个数,j列数
- Do
- j = j + 1
- If .Cells(i, j).Value <> "" Then n = n + 1
- If n > 0 And n Mod 2 = 0 Then .Cells(i, j).ClearContents: l = l + 1
- Loop Until l > y - 4
- End If
- Next
- .Select
- End With
- End Sub
复制代码
保留3个非零数字.rar
(12.06 KB, 下载次数: 3)
|
|