Variant/Double..../Single help

[edlim85]

hi guys,

Happy new year. hope you are going well.

i have a IF validation within FOR loop. it validates "IF .Cells(r, c).Value = .Cells(x, y).value Then"...perform task.
the problem i face is even my both cell have the same value the IF statement doesnt pass.

I realised that the problem is that VBA declare one of the cell as Variant/Double and the latter declare as Variant/Single. both cells have 4digits numeric values. Do you guys know how can i get ard this?


Thanks

 

[edlim85]

Sharks,

Got it. i jus have to declare the variable at start.