View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
theDude[_18_] theDude[_18_] is offline
external usenet poster
 
Posts: 1
Default Comparing slightly different strings


If the variables are actually dimensioned as String type, it should
work:

Code:
--------------------
Dim Nums1 As String, Nums2 As String

Nums1 = "12341234123"
Nums2 = "1234.123.4123"
If Nums1 < Nums2 Then
MsgBox "Not the same"
Else
MsgBox "They match"
End If
--------------------

Hope this helps,
theDude


--
theDude
------------------------------------------------------------------------
theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550
View this thread: http://www.excelforum.com/showthread...hreadid=391086