I have a script that turns a single line break within an Excel cell into two. The code is pretty simple:
Set Cel = ActiveCell
For c = Cel.Characters.Count To 1 Step -1
If Cel.Characters(c, 1).Text = vbLf Then
Cel.Characters(c, 1).Insert (vbLf & vbLf)
End If
Next c
It works in most instances but there are places where the .Insert command doesn't have any affect. I know there are VbLf there and they're being "found" but the Insert command doesn't always add the double VbLf.
Has anyone seen this not work properly?
Thanks,
Ken