Solved!
Code
Dim LevenshteinValue As Long
Dim LevenshteinValueCounter As Long
Dim ArrLevenshteinValues() As Variant
Dim b,c, d1, e1 As Long
LevenshteinValueCounter = 0
For b = 1 To VALUATIONTableRowCollection.Length - 1
Set VALUATIONRowObj = VALUATIONTable.Rows(b)
c = 1
Set VALUATIONRowCompanyNameCellObj = VALUATIONRowObj.Cells(c)
LevenshteinValue = Levenshtein(Range("D6").Value, ExtractVName(VALUATIONRowCompanyNameCellObj))
LevenshteinValueCounter = LevenshteinValueCounter + 1
ReDim Preserve ArrLevenshteinValues(1 To LevenshteinValueCounter)
ArrLevenshteinValues(LevenshteinValueCounter) = LevenshteinValue
Next
For d1 = 1 To LevenshteinValueCounter
Debug.Print ArrLevenshteinValues(d1)
Next
e1 = Application.Match(Application.Min(ArrLevenshteinValues), ArrLevenshteinValues, 1)
Debug.Print "Least Value is : " & ArrLevenshteinValues(e1) -
[B]Solution : Least Value is : [/B] [B]8[/B]
Display More
[TABLE="border: 1, cellpadding: 1, width: 500"]
String1
[/td]String2
[/td]LevenshteinValue
[/td]Vardhaman Laboratories Ltd
[/td]Sun Pharma
[/td]18
[/td]Vardhaman Laboratories Ltd
[/td]Aurobindo Pharma
[/td]18
[/td]Vardhaman Laboratories Ltd
[/td]Lupin
[/td]20
[/td]Vardhaman Laboratories Ltd
[/td]Piramal Enterp
[/td]15
[/td]Vardhaman Laboratories Ltd
[/td]Glenmark Pharma
[/td]18
[/td]Vardhaman Laboratories Ltd
[/td]Dr Reddy's Labs
[/td]18
[/td]Vardhaman Laboratories Ltd
[/td]Cadila Health
[/td]17
[/td]Vardhaman Laboratories Ltd
[/td]Vardhaman Labs
[/td]8
[/td]
[/TABLE]