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 vote195 views1 answer
Visual basic run command
VBA
1 vote157 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote155 views1 answer
Vba createparameter null
VBA
0 vote161 views1 answer
Vba string start with
VBA
0 vote166 views1 answer
Add text to combobox drop down vb
VBA
0 vote147 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote151 views1 answer
Replace spaces with underscores vbnet
VBA
3 votes159 views1 answer
Excel vba make long from two shorts
VBA
4 votes163 views2 answers
Vba array length
VBA
-1 vote184 views1 answer
Code for reading letters only in vb 6
VBA