Sub 查找上色()
s = InputBox("请输入查找的编号", , 5)
With Sheet1.[A:C]
Set c = .Find(s, LookIn:=xlValues, After:=[B1], SearchOrder:=xlByRows)
If Not c Is Nothing Then
firstAddress = c.Address '记录第一个找到的地址
Do
c.Interior.Color = 49407
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
End Sub