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 vote334 views1 answer
Limit combobox to list vba
VBA
0 vote331 views1 answer
Excel vba automatic calculation
VBA
0 vote341 views1 answer
Vbnet chart make 0 gridline line different color
VBA
1 vote316 views2 answers
Excel vba password protect
VBA
0 vote338 views1 answer
Vbnet hex to binary
VBA
1 vote339 views1 answer
Excel vba compare 2 rows
VBA
0 vote321 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote355 views1 answer
Add text to Shape VBA
VBA
0 vote339 views1 answer
Vbnet click on dgv cells
VBA
1 vote332 views1 answer
Vba refresh pivot table
VBA