Is the decimal point significant? Looks to me like Range is of type double.
Just as an experiment, I added the decimal point to the two test cases from my first post and it made no difference, so that kind of type mismatch wasn't the problem. Thanks for the suggestion, though, it was a good hypothesis.