Hello everyone
In these two macros the first return True and the second returns False
Sub Test()
Dim s As String, i As Integer
s = Range("A2").Value
i = 5
Range("C1").Value = Right(s, i)
Debug.Print Right(s, i) = String(5, vbTab)
End Sub
Sub Test2()
Dim s As String, i As Integer
s = Range("A2").Value
i = 6
Range("C1").Value = Right(s, i)
Debug.Print Right(s, i) = vbCrLf & String(5, vbTab)
End Sub
Why the second macro returns False ..?
I have copied the value of A2 to notepad++ and found that before the 5 tabs there is line carriage but VBA doesn't detect it
How can I detect the vbCrLf ?
Bookmarks