![]()
Sub bb() Dim cell As Range numrow = ActiveSheet.UsedRange.Rows.Count Set Rng = ActiveSheet.Range("O7:S" & numrow) For Each cell In Rng If Not IsDate(cell.Value) Then For i = 1 To Len(cell.Text) With cell.Characters(i, 1) If .Font.Bold Or .Font.Italic Or .Font.Strikethrough _ Or .Font.Superscript Or .Font.Subscript Or .Font.OutlineFont _ Or .Font.Shadow Or .Font.Color > 1 Then Else MyText = MyText & .Text End If End With Next i cell.Value = MyText cell.Font.ColorIndex = 1 cell.Font.Strikethrough = False Do While Left(cell.Text, 1) = vbLf cell.Value = Right(cell.Text, Len(cell.Text) - 1) Loop MyText = "" End If Next End Sub
Bookmarks