如下代码:
如何进行更改达到标题的效果
Sub ss()
Dim i As Long, k As Long
For i = 2 To Range("a65536").End(xlUp).Row
If Range("e" & i) = "删除" Then
Range("e" & i).EntireRow.Cut
End If
k = Range("a65536").End(xlUp).Row + 1
ActiveSheet.Range("a" & k).Select
ActiveSheet.Range("a" & k).PasteSpecial
k = k + 1
Next i
End Sub
IF 语句里是想实现满足“删除”值,然后剪切到最后非空单元格空两行的单元格里进行粘贴然后在对剪切掉空白行进行删除
Dim i As Long, k As Long, j As Long
j = Range("a65536").End(xlUp).Row
k = Range("a65536").End(xlUp).Row + 3
For i = 2 To j
If Range("e" & i) = "删除" Or Range("e" & i) = "合并" Then
Range("e" & i).EntireRow.Cut Cells(k, 1)
Range("e" & i).EntireRow.Delete
End If
Next i