Forum Discussion

anthonyjb's avatar
anthonyjb
Copper Contributor
May 24, 2019

New Line Break within a cell

Is there a way to show Line Break symbol and other hidden characters in a cell similar to how Word does?
excel
Berndvbatanker's avatar
Berndvbatanker
Iron Contributor
May 24, 2019

anthonyjb 

Hi,

ok i didn't know such a function, but the following macro color all cells in selection with Line breaks.

 

Sub ColorLineBreak()
Dim rngCell As Range

For Each rngCell In Selection

If InStr(rngCell.Text, vbLf) > 0 Then
rngCell.Interior.ColorIndex = 3
End If

Next rngCell


End Sub

 

Best regards 

Bernd

http://www.vba-Tanker.com