For Each wks In ActiveWorkbook.Worksheets
If wks.Name <> "目录" Then
With wks.Cells
Set rCell = .Find(what:="*AC", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchByte:=True, MatchCase:=False, SearchFormat:=False)
If Not rCell Is Nothing Then
szFirst = rCell.Address
Do
rCell.Offset(qh, ql) = " 数字 "
Set rCell = .FindNext(rCell)
i = i + 1
Loop While Not rCell Is Nothing And rCell.Address <> szFirst
End If
End With
End If
Next wks
这是我用的一段代码,你自己改一下