删除包含特定字符串的单元格所在的行 [
|
Sub 删除ppn() Dim cll As Range For Each cll In Range("F1:F40000") If InStr(cll, "PPN") Then cll.EntireRow.Delete End If Next End Sub |
|
Sub 删除ppn() Dim cll As Range For Each cll In Range("F1:F40000") If InStr(cll, "PPN") Then cll.EntireRow.Delete End If Next End Sub |