Unexpected error 13: Type mismatch

C

ChrisX

I'm working on an Excel worksheet that someone else created, and every time I
open the worksheet I initially get this error, for which I have to click "OK"
several times, then it goes away:

"Unexpected error 13: Type mismatch"

Can anyone help me troubleshoot how I can locate the source of this in the
worksheet, and/or how I can eliminate this error message.

Thanks,

Christos X
 
J

Jim Thomlinson

Right click on the XL icon next to the word File in the XL menu. Select View
Code. When the VBE code window opens look for a sub procedure that starts
with

Private Sub Workbook_Open()

This code executes each time the workbook is opened. Chances are it is
reading data from a sheet that is no longer what it expects to find. (Cells
contain strings when the code expects numbers or something else similar as
such). Post the code that you find there and we can give you a hand if you
need further help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error 13 type mismatch input box 1
Not getting "argument type mismatch" 4
Error 13 - Type Mismatch 1
13 - Type mismatch 4
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Unexpected error has occured - AutoRecover has been disabled 1
run-time error 13: Type mismatch? 2
Avoiding error on Input Box - if no value is entered 5

Top