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

8 votes228 views1 answer
Excel vba determine number of elements in a 1D array
VBA
4 votes218 views2 answers
Vba last row
VBA
1 vote209 views1 answer
Excel vba get column name from number
VBA
0 vote298 views1 answer
Vba array of integers
VBA
0 vote202 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote226 views1 answer
Send webhook vbscript
VBA
0 vote224 views1 answer
Excel named range sum
VBA
0 vote224 views1 answer
Vba test optional argument
VBA
0 vote240 views1 answer
Vba integer to double
VBA
18 votes296 views3 answers
Excel-vba make integer
VBA