Hi, I wrote a macro for someone and in this macro there is a section where i take a string.....strip off special character and spaces and i am left with somethign like this "198.40"
Basically a string.
i then use CDbl to convert it to a number.
Junk1=CDbl("198.40")
but for some reason i get a type mismatch error at this line...........welll actually my friend gets a type mismatch error at this point ......AND I DO NOT get error.
ANy ideas?
Note: i can not publish code with example files as some have private information.
Bookmarks