Thanks to ALL (you guys) for your input;
It's on my PC at work -- I'm now at home.
I'll get into it tommorow WITH your thoughts/comments.
with appreciation...
Jim

"Mark Lincoln" wrote in message
oups.com...
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.