Sub MyClear() With ActiveSheet For i = 5 To .Range("B65536").End(xlUp).Row If .Cells(i, 2) <> "停学" Then .Range(.Cells(i, 5), .Cells(i, 7)).ClearContents End If Next i End With End Sub
Sub MyClear() With ActiveSheet For i = 5 To .Range("B65536").End(xlUp).Row If .Cells(i, 2) <> "停学" Then .Range(.Cells(i, 5), .Cells(i, 7)).ClearContents End If Next i End With End Sub