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

2 votes191 views2 answers
Excel vba if sunday or staurday
VBA
5 votes199 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote160 views1 answer
Vba check 32 or 64 bit
VBA
0 vote163 views1 answer
Vlookup columns not next to each other
VBA
0 vote163 views1 answer
Vba get text file content
VBA
3 votes174 views1 answer
Vba make long from two shorts
VBA
0 vote169 views1 answer
Vba compare strings
VBA
0 vote160 views1 answer
Vba add shape oval
VBA
0 vote168 views1 answer
Vbnet chart make 0 gridline line different color
VBA
5 votes167 views1 answer
Excel formula how to create strings containing double quotes
VBA