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

31 votes447 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote299 views2 answers
Excel vba prevent save
VBA
0 vote306 views1 answer
Vba len variant
VBA
0 vote380 views1 answer
Excel vba delete columns in range
VBA
1 vote297 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote318 views1 answer
Excel vba last column in range
VBA
0 vote312 views1 answer
Vba add shape oval
VBA
1 vote293 views1 answer
Close form vba
VBA
0 vote305 views1 answer
Internet explorer reference vba
VBA
0 vote310 views1 answer
Xlbycolumns is not declared
VBA