Type Mismatch Error

[clto0501]

Hi Everyone,
I am currently using a code that automatically copies a row to the next blank row in Sheet 5 when a date is entered into Column 14 and then deletes the row. The only problem is that if I start typing into the wrong row and delete the text before clicking off that wrong cell, the code still runs. I have tried two different versions of the code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Both of these codes have the problem I discussed above. In an attempt to fix it (Since I am entering a date into Column N) I changed the If statement to:

Please Login or Register  to view this content.

Now, if I start typing into the wrong cell and delete the text before clicking off the cell, the code does not run which is what I want. If I enter a date, the code runs correctly, but I get a "Type Mismatch Error" when it is completed. The debugger shows that the error is in the statement that I changed. I can't seem to figure out why this is happening, and I'm about to start banging my head against the wall. I wouldn't even worry about this, except that I am not the one that will be entering data into the sheet. If the person using the spreadsheet makes a mistake, they won't know how to fix it.

[stnkynts]

Please Login or Register  to view this content.

[clto0501]

Thank you! That works perfectly. Can you tell my why the value has to be a separate If statement?

[stnkynts]

It doesn't. I just prefer it that way. The issue you were having was the Target.Value > 0 line. That is what was causing the mismatch. By having it within the same if statement everytime there is a worksheet change event you test it against every parameter within that if statement. So if you make a change to B4 it tests to see if the column is 14 and if B14 value > 0, hence the possible for mismatch. (Note: Target.Value > 0 and Target.Value > "0" are completely different)

When using worksheet change I find it best specify the range test first (to ignore all unwanted change events) then any other tests later.

[clto0501]

I understand. Thanks again!