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

Hi,

Alt F11 to open VBA ... and fix the issue ...

Good Luck

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

Jim Thomlinson


"ChrisX" wrote:

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