Runtime error

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

We have a large Excel document with many tabs that
intertwine via functions. However, when we open it and
click on the first tab which contains a chart (that pulls
data from the other tabs), we get this message: "Runtime
Error 13; type mismatch."

This error seems to be throwing garbage data into the
cells of that document and any other Excel worksheets that
are open at the time. It is causing us a lot of grief and
I would appreciate if anyone could help out. Another
employee seems to think he once saw an error message pop
up about something wrong in Visual Basic, but I could not
even find any macros currently running (my VB skills are
very weak at this time). Thanks!

Sandra
 
Sandra said:
We have a large Excel document with many tabs that
intertwine via functions. However, when we open it and
click on the first tab which contains a chart (that pulls
data from the other tabs), we get this message: "Runtime
Error 13; type mismatch."

This error seems to be throwing garbage data into the
cells of that document and any other Excel worksheets that
are open at the time. It is causing us a lot of grief and
I would appreciate if anyone could help out. Another
employee seems to think he once saw an error message pop
up about something wrong in Visual Basic, but I could not
even find any macros currently running (my VB skills are
very weak at this time). Thanks!
Click to expand...

Sandra,

Error 13 type mismatch is a VBA error.

You need to find the vba code and resolve the problem.

Best regards,
Kevin
 
Back
Top