|
Sub 宏1()
Dim Sht As Worksheet, i%
For Each Sht In Worksheets
If Sht.Name <> "要求" Then
Sht.Activate
For i = 1 To Range("A" & Rows.Count).End(xlUp).Row
If Cells(i, 1).MergeCells Then
If Cells(i, 1) Like "*课程表" Then
Cells(i, 1).Font.Name = "仿宋"
Cells(i, 1).Font.Size = 20
Cells(i, 1).Font.Color = -16776961
Cells(i, 1).Interior.Color = 65535
Else
Cells(i, 1).Font.Name = "仿宋"
Cells(i, 1).Font.Size = 18
End If
End If
Next i
End If
Next Sht
End Sub
|
|