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

1 vote135 views1 answer
Ms access open form to new record
VBA
0 vote200 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote176 views1 answer
Vba line feed
VBA
0 vote194 views1 answer
Excel vba combine ranges
VBA
-1 vote210 views1 answer
Code for reading letters only in vb 6
VBA
0 vote214 views4 answers
Vgrive,deb
VBA
0 vote196 views1 answer
Vba get relative cell address
VBA
0 vote175 views1 answer
Excel vba existence of a file
VBA
0 vote190 views1 answer
Vba excel parser xml
VBA
0 vote185 views1 answer
Label de tableau dans des label.text en VBA
VBA