Fun with Excel
Frankly, this is starting to look like a bug but I didn't want to jump the gun. I'm using a spreadsheet that has input and expected outputs in their respective columns. I'm taking the results ...
Forum Discussion
After this new loop is added to the beginning of the script, I get an error: "An exception occurred...The argument is not a number." right at the "numOne = aqConvert.StrToFloat()" spot.
My question is - "Why am I getting this exception?"
I'm curious as to what the actual contents are of the cell in question. If the contents don't map to a numerical value (like if they contain a comma, an alpha character, etc), then they cannot be converted from the string to the numerical value of the float.
Have you tried putting a breakpoint on that line and seeing what the value of the cell is? I'm guessing that it's not "Null" but some other empty object. You might want to use a different check to bypass "empty" values. Try Jared's suggestion in http://smartbear.com/forums/forum/post/?mode=singleThread&thread=6e5fb87a-4a1c-45d7-bb64-17a28e8f62cc
