要加粗的部分有规律吗
追问加粗的是相同的文字,但单元格中有转段,内容也不相同。谢谢!
追答Sub s()
n = Cells(Rows.Count, 2).End(3).Row
For I = 1 To n
T = Cells(I, 2)
k = 1
p = InStr(k, T, ":", vbTextCompare)
Do While (p <> 0) And (k <> 0)
Cells(I, 2).Characters(k, p - k).Font.FontStyle = "加粗"
k = InStr(p, T, Chr(10), vbTextCompare)
If k Then p = InStr(k, T, ":", vbTextCompare)
Loop
Next
End Sub
本回答被提问者和网友采纳