|
楼主 |
发表于 2015-8-8 15:25
|
显示全部楼层
zez 发表于 2015-8-8 11:31
Sub Macro1()
For N = [a65536].End(xlUp).Row To 2 Step -1
If Cells(N, 1) = Cells(N - 1, ...
谢谢回复。
对于多重复行,需要多次运行此删除代码
ii+1绕过要删除的重复行
DesgRng(ii + 1)
代码如下,代码需要进一步优化。
- Private Sub DelReplRow1()
- Dim Rng As Range, oRng As Range, oRng1 As Range, oRng2 As Range, DesgRng As Range
-
- Dim DesgRngStr
- ''
- DesgRngStr = "A3:A45"
-
- Set Sht = Application.ActiveSheet
- ''
- Col = Sht.Range("AF2").End(xlToLeft).Column
- ''
- Set DesgRng = Sht.Range(DesgRngStr)
- For ii = 1 To DesgRng.Rows.Count
- If DesgRng(ii, 1) = DesgRng(ii + 1, 1) Then
- Set oRng = Sht.Rows(DesgRng(ii + 1).Row)
- Sht.Rows(oRng.Address).Select
- oRng.Delete Shift:=xlShiftUp
- End If
- Next ii
-
- End Sub
复制代码
|
|