Reasons for "Run-time error '13':Type mismatch"?

[BagaAzul]

Hi everyone,

I’m using an Excel tool that runs well in my computer (unfortunately
have no access to the code). When my colleague runs it in his compute
it gives “Run-time error '13':Type mismatch”. Apparently there is n
difference in the data entered in the program. My guess is that hi
computer has a different configuration (country, data type...) o
operating system version, that changes the data type. Anyone knows ho
to solve this problem? What to change so both computers run the tool?

Thanks in advance!
Paul

 

[Guest]

Just a guess, but if your colleague is using xl97 (or perhaps earlier), it
was less forgiving in some types of comparison operations. If this is the
case, then the code won't work. Even if he or she isn't using xl97, it
could be a similar type problem (your version of excel is newer than his - so
it is more forgiving).

 

[BagaAzul]

Thanks Tom!

Actually his computer is new, so he should have the newest version o
everything... Still looking for the problem...

Thanks!
Paul