|
发表于 2017-1-2 18:39
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, i&, j%
- arr = Range("a1").CurrentRegion
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- zf = arr(i, j): p = ""
- For k = 1 To Len(zf)
- With Cells(i, j).Characters(k, 1).Font
- If .Size <> 1 And .ColorIndex <> 2 Then p = p & Mid(zf, k, 1)
- End With
- Next
- arr(i, j) = IIf(p <> "", "'" & p, "")
- Next
- Next
- With Range("a1").CurrentRegion
- .Clear
- .Font.Name = "宋体"
- .Font.Size = 9
- .Font.ColorIndex = 1
- .Value = arr
- End With
- End Sub
复制代码 |
|