excel - string and numeric value when equal returns true -
why 5.5 = "5.5" return true in vba?
is acceptable practice direclty compare numeric values string values in vba?
this returns true
if 5.5 = "5.5" ...
this might shut-down opinion-based more anything, yes acceptable. used when comparing cell values numbers, or adding cell values, example. ie if cells contain string such abcde123, , want use 123, take 3 right characters of string , use them directly. if want rigorous use cint(string) not think necessary.
Comments
Post a Comment