|
发表于 2012-11-25 14:03
|
显示全部楼层
本楼为最佳答案
- Sub zhengli()
- Dim i As Long, j As Long, k As Long
- Dim x As Long, y As Long, z As Long
- Dim s1 As String, s2 As String
- Dim rg As Range
- On Error Resume Next
- Application.ScreenUpdating = False
- Application.Calculation = xlCalculationManual
- z = Range("a:a").Find("%").Row
- For i = 1 To z - 2
- For j = i + 1 To z - 1
- If Right(Trim(Cells(i, 1)), 6) = Right(Trim(Cells(j, 1)), 6) Then
- If Cells(j, 5) <> "标识孔" Then
- s1 = "T" & Val(Mid(Cells(i, 1), 2, 2))
- s2 = "T" & Val(Mid(Cells(j, 1), 2, 2))
- Set rg = Range("a:a").Find(s2, , , xlWhole)
- If Not rg Is Nothing Then
- x = rg.Row
-
- 'If Not Range("a:a").Find(s2, , , xlWhole) Is Nothing Then
- 'x = Range("a:a").Find(s2, , , xlWhole).Row
- y = x
- Do
- y = y + 1
- Loop Until Len(Trim(Cells(y, 1))) < 4
- Range(Cells(x, 1), Cells(y - 1, 1)).Cut
- Range("a:a").Find(s1, , , xlWhole).Insert shift:=xlDown
- Set rg = Nothing
- Exit For
- End If
- End If
- End If
- Next
- Next
- Application.Calculation = xlCalculationAutomatic
- Application.ScreenUpdating = True
- End Sub
复制代码 代码结果楼主就自己验证下吧。 |
|