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 vote315 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote291 views1 answer
Excel protect cells with formulas
VBA
0 vote311 views1 answer
Vba string
VBA
6 votes327 views1 answer
Excel vba get the path of current workbook
VBA
1 vote265 views1 answer
Vba listindex select multiple items vba
VBA
0 vote277 views1 answer
Excel R1C1 mode
VBA
5 votes334 views1 answer
Xlvba double quotes in string literal
VBA
0 vote281 views1 answer
Refresh token em vb net
VBA
1 vote298 views1 answer
VBA Loop through recordset
VBA
0 vote307 views1 answer
Vba is integer
VBA