View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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