type mismatch '13' after deleting field with DEL button

Hi,
I got a problem, which I can't solve since 3 weeks. I've already read a lot of forums about this error, and basically I know how to deal with it, but I wrote an application with over 15000 lines (VBA) and still can't solve this issue.

And the problem is, that I want to calculate a sum of few particular fields. So if entered a loop goes thru those fields and checkes if those are digits

Please Login or Register  to view this content.

I know what to do, if there are no digits or/and the cell is empty. It works OK if I clear the field value with BACKSPACE and press ENTER. But when I want to clear the field with DEL button on the keyboard I get the TYPE MISMATCH '13' error (and debugger stops at the line shown above). Even If I stop checking this value, application stops at the line, where I want assign the value to the variable:

Please Login or Register  to view this content.

price_is defined as Public variable As Integer


whatever I try:
...... Cint(target), isNull(target), isEmpty(target) or much more it doesn't help.
I'm desperated to finish my app, but without this I have to tell to others not to touch the DEL button, what is ridiculous.

PLEASE, help.

Greetings,
Mike

1) Edit your post above to add code tags around the code, like so:

Please Login or Register  to view this content.

2) Restructure your function to test the value....

Please Login or Register  to view this content.

Change the code to:

Please Login or Register  to view this content.

and tell us what the message says.

You've got merged cells there, haven't you?

Try changing the original code to use:

Please Login or Register  to view this content.

so that it only refers to the first of the merged cells.

...and this is only the first of many griefs introduced by merging cells and not telling anyone.

Hi,

Better still avoid merged cells altogether. They just cause problems.
If you're using them for formatting reasons then a much tidier solution is to use the Format cells horizontal 'center across selection' option.