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 vote136 views1 answer
Excel protect cells with formulas
VBA
0 vote144 views1 answer
Vba leading zeros in string
VBA
3 votes144 views1 answer
Excel vba read registry key value
VBA
0 vote148 views1 answer
Excel vba formatconditions range
VBA
0 vote139 views2 answers
Excel vba copy paste after last row
VBA
0 vote149 views1 answer
Vba nested dictionary
VBA
6 votes163 views1 answer
Excel vba get the path of current workbook
VBA
0 vote153 views2 answers
Do until loop vba
VBA
4 votes147 views1 answer
Vba create directory
VBA
0 vote139 views1 answer
Vba first cell in range
VBA