troubles working with double

hello guys i'm trying to compare two columns but the problem is that when the value is double i can't compare it;
if the value is string then i can work normal with it but if it's double the programme stop working telling me that it had problems converting double to object can you please suggest me how to solve this problem.

in my columns i have values like cell 1 :2235
cell2 2685
cell 3 D2568
cell 4 E695
cell 5 3256

so i can't compare the value that is double to a value that is string
P.S i only added the part of the program where the problem is .

Code:

---

  Dim findme1 As Excel.Range = ws1.Range("A4:A" & Range1.Rows.Count)
            Dim findme2 As Excel.Range = ws2.Range("F5:F" & Range2.Rows.Count)
            Dim MyArray As Object(,) = CType(findme1.Value, Object(,))
            Dim MyArrayy As Object(,) = CType(findme2.Value, Object(,))
for n=1 to MyArray.length
for m=1 to MyArrayy.length
if MyArray(n,1)=MyArrayy(m,1) then  ' can't convert string to doubt
....
end if
next m
next n

---

This seems to be a typo:

Code:

---

if MyArray(n,1)=MyArrayy(m=1) then

---

Presumably you wanted: m, 1

Currently you are only specifying one dimension of a 2 dimensional array.

i work with Myarray(n,1) and i did put it in textbox to see the result and does indeed contain the value of the cell

I'm not sure whether that line would ever work, even if that typo were fixed. You are boxing the doubles into objects. A double is a value type, an Object is a reference type, so what you have in those arrays seem like they would be addresses of the actual values. You would normally compare two references with Is or IsNot, not equals. In any case, you don't want to be comparing the addresses, because they will NEVER be equal, in the case shown. You'd want to compare the underlying doubles. VB may be doing that, if it is implicitly converting from Object back to Double, but relying on that isn't a good idea. You already found that you could convert them to strings and compare them, what happens if you convert them to Double with CDbl() and compare those?

even if i try to use CDbl() it doesn't work and return the same problem (can't convert string into double : this is what it shows me " 'Conversion from string "D404" to type 'Double' is not valid.' ")

btw to Myarray i add findme1.value so i'm adding the value in the range not the range so i don't thing that th Myarray contains ranges ? or am i range ? can you correct me please

and do you have any idea how to stock the value of the cell rather than the addresses please ? and thank you so much

Of coarse you can't convert "D404" to a double. Is that actually the value you want to convert to a double? If so, you need to strip off the "D" first.

Why not compare all of your values as strings?