|
发表于 2013-11-25 11:06
|
显示全部楼层
本楼为最佳答案
- Sub TEST()
- Application.ScreenUpdating = False
- Dim m&, j&
- s: For m = Sheets("rK").Range("b1048576").End(xlUp).Row To 399 Step -1
- If Sheets("rK").Range("b" & m) = 0 Then
- For j = 1 To Sheets("Slj").[xfd1].End(xlToLeft).Column Step 2
- If Trim(Sheets("Slj").Cells(1, j)) = Sheets("rK").Cells(m, "a") Then
- Union(Sheets("Slj").Columns(j), Sheets("Slj").Columns(j + 1)).Delete shift:=xlToLeft
- Sheets("rK").Rows(m).Delete shift:=xlUp
- End If
- Next j
- End If
- Next m
- Sheets("Sl").Range("a1:b" & Sheets("Sl").Range("b1048576").End(xlUp).Row).Copy
- Sheets("Slj").Range("a5").End(xlToRight).Offset(0, 1).PasteSpecial Paste:=xlPasteValues
- ' Sheets("Slj").Range("xfd5").End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValues
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|