Sub 直接改()
Dim RG As Range
With ActiveSheet
For Each RG In .Range(.Cells(2, 1), .Cells(.Cells(Rows.Count, 1).End(xlUp).Row, 1))
With RG.Characters(Len(RG) - 3, 4).Font
.FontStyle = "加粗"
.Size = .Size + 1
End With
Next
End With
End Sub
Sub 复制粘贴()
Dim SH As Worksheet, RG As Range
Set SH = ActiveSheet
Sheets.Add(, Sheets(Sheets.Count)).Name = 2 '创建工作表命名为2
SH.Range("a:a").Copy Sheets("2").Range("a:a")
With ActiveSheet
For Each RG In .Range(.Cells(2, 1), .Cells(.Cells(Rows.Count, 1).End(xlUp).Row, 1))
With RG.Characters(Len(RG) - 3, 4).Font
.FontStyle = "加粗"
.Size = .Size + 1
End With
Next
.Range("a:a").Copy SH.Range("a:a") '粘贴回数据
End With
'Sheets("2").Delete '删除工作表
End Sub