Dim sht As Worksheet
Dim i%, a As Range
For i = 1 To Sheets.Count
For Each a In Sheets(i).UsedRange
If a.Value Like "*制表*" = True Then
j = a.Row()
Sheets(i).Range("A5:A" & j).RowHeight = 16
k = Sheets(i).Range("B:B").Find("合计").Row
Rows(k + 1).Select
Selection.Font.Bold = True
End If
Next a
Next i
Application.ScreenUpdating = True
End Sub
工作簿里有若干个工作表,我想在各表的“合计”栏的下一行实现字体加粗,可实现不了,帮我看下代码错在何处?