- Sub YuBa()
- Dim rng As Range, s$, m%, n%, i%
- m = Sheet1.[e65536].End(3).Row
- For i = m To 1 Step -1
- Set rng = Cells(i, "e")
- If InStr(rng.Value, "*") Then
- rng.Copy rng.Offset(1, 1)
- Rows(rng.Row).Delete
- ElseIf InStr(rng.Value, "解释:") Then
- rng.Copy rng.Offset(1, -1)
- Rows(rng.Row).Delete
- End If
- Next
- End Sub
复制代码 |