Runtime Error 13 - Please help!

[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

PS I am running Excel 2000 on both Windows 2000 and XP
computers using this workbook.

 

[kkknie]

If the error comes up when you click on this new tab, there is probabl
an event procedure with the error. An event procedure is triggere
when you do certain things (such as activate a new workbook tab b
clicking on it) and if there is some flawed code in there, it wil
cause the error.

Right click on the worksheet tab which is causing the error and selec
View Code. This will take you to any code that is associated with th
worksheet. The error may be in the Worksheet_Activate() event o
somewhere else.

Error #13 is raised when you try to stuff the wrong kind of data into
variable. For example, if you have a variable called i and it i
declared as an integer and try to put a string into it, you will ge
this error. Something like:

Dim i As Integer

i = "ABC"

will cause this error.

Post back what you find.

 

[Guest]

Thanks for your explanation. However, when I go in to
view the code, there is no code to view. This does not
really make sense to me because I know every spreadsheet
has at least some code. However, your explanation of
putting the wrong kind of data into a variable could be
correct, as we could have labeled certain cells as numbers
but actually put text into them (that will cause this
problem, right?). I will keep looking, but please help if
you have any other input.

Sandra