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

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

--
BagaAzu
-----------------------------------------------------------------------
BagaAzul's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=52313

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

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).

--
Regards,
Tom Ogilvy


"BagaAzul" wrote:


Hi everyone,

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

Thanks in advance!
Paula


--
BagaAzul
------------------------------------------------------------------------
BagaAzul's Profile: http://www.excelforum.com/member.php...o&userid=32529
View this thread: http://www.excelforum.com/showthread...hreadid=523134

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

Thanks Tom!

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

Thanks!
Paul

--
BagaAzu
-----------------------------------------------------------------------
BagaAzul's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=52313