|
Sub Clear2()
Dim ws As Worksheet
Dim rng As Range
For i = 4 To 6 '需事先确认A,B,C的位置
With Sheets(i)
Set rng = .Range(.Cells(1, 2), .Cells(50, 2)).find("Q", LookIn:=xlValues)
If Not rng Is Nothing Then rng.Resize(4, 5).ClearContents Else MsgBox "No match found. "
End With
Next i
End Sub
Find and clear2.rar
(25.9 KB, 下载次数: 3)
|
|