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 vote142 views2 answers
Excel vba delete empty rows
VBA
1 vote143 views1 answer
Excel vba first row in range
VBA
0 vote148 views1 answer
Tester si une case est vide vba
VBA
5 votes133 views1 answer
Excel vba high word from Long Integer
VBA
0 vote136 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
-1 vote131 views1 answer
Vba code to add new column in table
VBA
0 vote116 views1 answer
Docker vboxmanage not found
VBA
0 vote137 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote122 views1 answer
Vba verticalalignment
VBA
0 vote78 views1 answer
How to sort datagridview in vb.net
VBA