Run Time Error 13 . Type mismatch

Hi

I have recently been having an issue with a macro that i am trying to run. Up until yesterday it ran perfectly but now it is unable to complete running. it generates a message that says "run time error 13, type mismatch". i have attached a sample of my schedule that i am trying to run the macro on. There are 31 pages with a lot more detail on the original schedule. Unfortunately i am unable to attach it here as it is too big.

Excel Test.xlsm

If i debug the macro the following line is highlighted:

Please Login or Register  to view this content.

Here is the full macro:

Please Login or Register  to view this content.

Thanks for your help
Terri

I run the code and I did not get any error.

Originally Posted by AB33

I run the code and I did not get any error.

Hi

I deleted some info on the attachment and now i see that it runs. However when i try to run it on the master there is an issue. I wish I could attach the whole file.

I will see if i can attach a bigger sample

I do not know, but I could not imagine why the code fails on this line if the condition is false, it should skip that row.

Please Login or Register  to view this content.

Unless there is an error on column I.

Hi

I have attached a different sample here and i think i have found the issue. On sheet 26 in one of the columns my formula has generated an answer that is "value" . i have no idea why it has generated this answer. Can anyone help. if i manually fix this error it will then run.

Thanks
Terri




June Sample.xlsm

To avoid the error, I have added an error trapping line. My guess was right. The code will error on any line if the cell has an error on it.

Please Login or Register  to view this content.

Hi

I have no idea why it created an error. If you go further done on sheet 26 there are some other rows that are similar but they did not create an "error". why would this row create an error? I will try your macro in the morning. Thanks so much for your help any way.

Terri

In maths, you can not divide a number by zero. Well, you can, but you get an infinite number, but in a computer you get no value which is an error.

I understand that but i am confused as to why it did not generate the same results on rows 27,28,30 and 31 on sheet 26

If I put this formula in J27

=ISBLANK(J27)

it returns true, which means the cell is blank and the formula will return 0, but put the same formula in J10, you get false which means that cell is not blank

=ISBLANK(J10)