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 vote365 views1 answer
Vba collection key list
VBA
0 vote364 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote358 views1 answer
Dynamic array vba
VBA
1 vote366 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote375 views1 answer
Excel VBA web scraping
VBA
0 vote390 views1 answer
Vba excel parser xml
VBA
5 votes421 views1 answer
Excel vba low word from Long Integer
VBA
31 votes516 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote354 views1 answer
Vba full date format
VBA
0 vote446 views2 answers
Excel vba store array and write to sheet
VBA