Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing text strings | Excel Worksheet Functions | |||
Comparing slightly differing columns | Excel Discussion (Misc queries) | |||
problem with comparing strings in VBA | Excel Discussion (Misc queries) | |||
Comparing text strings in cells | Excel Discussion (Misc queries) | |||
Comparing text strings in cells | Excel Discussion (Misc queries) |