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 vote218 views1 answer
Vba nested dictionary
VBA
0 vote240 views1 answer
Vba range clear formatting
VBA
12 votes494 views1 answer
Excel vba write string to text file
VBA
6 votes250 views1 answer
Excel vba isalpha
VBA
0 vote214 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote231 views1 answer
Vba loop through textboxes
VBA
0 vote214 views1 answer
Vb net check if file exists
VBA
0 vote217 views1 answer
Vbs exec hidden
VBA
1 vote226 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote159 views1 answer
Vba select file in folder
VBA