你可以使用以下 VBA 代码来删除电子表格中含有某个关键字的行:
Sub DeleteRows() Dim rng As Range Dim cell As Range Dim delRng As Range
' 设置要搜索的范围
Set rng = Range("A1:D10")
' 遍历范围中的每个单元格
For Each cell In rng
' 如果单元格包含关键字 "delete"
If InStr(cell.Value, "delete") > 0 Then
'