Sub TEST()
Sheets(1).Copy
With ActiveWorkbook.Sheets(1)
For I = .Range("A65536").End(3).Row To 2 Step -1
If .Cells(I, "H") <> "√" Then Rows(I).Delete
Next
If MsgBox("你需要打印此表格吗吗?", 4 + 32 + 256) = 6 Then
.PrintOut
Else
ActiveWorkbook.Close False
End If
End With
End Sub
Sub TEST()
Sheets(1).Copy
With ActiveWorkbook.Sheets(1)
For I = .Range("A65536").End(3).Row To 2 Step -1
If .Cells(I, "H") <> "√" Then Rows(I).Delete
Next
.PrintPreview
End With
ActiveWorkbook.Close False
End Sub