用宏程序 流程:调用输入对话框输入关键字→全文搜索关键字→删除该行及下一行 Sub 删除关键字行程序() Dim s As String Dim i As Integer On Error Resume Next s = InputBox("请输入关键字", "提示") Cells.Find(What:=s).Activate i = ActiveCell.Row If MsgBox("是否删除关键字所在2行", vbOKCancel, "删除确认对话框") = vbOK Then Rows(i).Delete Rows(i).Delete End If End Sub追问