Vba remove last vbcrlf

' Removes the Line Break from the string if my string Ends with Line Break
Sub RemoveLineBreak(myString)
    If Len(myString) > 0 Then
        If Right$(myString, 2) = vbCrLf Or Right$(myString, 2) = vbNewLine Then 
            myString = Left$(myString, Len(myString) - 2)
        End If
    End If
End Sub

Source: stackoverflow.com

Similar codes

0 vote247 views1 answer
Excel vba scroll to cell
VBA
0 vote311 views1 answer
Vba line feed
VBA
1 vote228 views1 answer
Export datagridview to excel vb.net
VBA
0 vote201 views1 answer
Remove frist letter from string vbnet
VBA
0 vote243 views1 answer
Sendkeys vba selenium
VBA
0 vote236 views1 answer
Excel filter by date not working vba
VBA
0 vote210 views1 answer
Vba find last column in a row with data
VBA
0 vote243 views1 answer
Add Formula to Shape Text in VBA
VBA
11 votes491 views1 answer
Excel vba How to URL encode a string
VBA
7 votes234 views1 answer
Excerl vba array to range
VBA