右击工作表标签,查看代码,把下面的代码贴到VBA窗口,按一下F5
Sub chiefzjh()
Application.ScreenUpdating = False
Dim iMax, r%, c%
For r = 1 To [a65536].End(3).Row
iMax = WorksheetFunction.Max(Rows(r))
For c = 1 To Cells(r, 1).End(xlToRight).Column
If Cells(r, c).Value <> iMax Then Cells(r, c).ClearContents
Next c
Next r
Application.ScreenUpdating = True
End Sub
追问我怎么找不到这些代码