Jim,

The only ways I can get the macro to fail is to either enter the number
in C6 with a leading apostrophe ('44.00), which makes it a text entry,
or to enter it as 44,00 (using a comma instead of a decimal point).

If the values in column C are forced right-justified, that would make
this kind of problem harder to spot.

I hope this helps. If not, I sure would like to know what's happening.