Excel Runtime Error 13

[Albert Dicosta]

When I try to access Excel, I have encountered an error: “Excel Runtime Error 13”. So, to fix this error I have tried inbuilt Excel tool “File Recovery” mode. But still same error occur.

I have searched this query over this forum but didn’t find solution:
https://www.access-programmers.co.uk/forums/forumdisplay.php?f=55

After searched over Google, I have found few resources:


But, I still have no clue. URGENT HELP!

 

[isladogs]

Don't spend money purchasing a tool to fix this

Error 13 indicates a type mismatch e.g. trying to use a text string in a number field. Without you giving specific details, any specific responses will be guesswork

A Google search will give lots of hits. Try this: https://www.google.co.uk/search?q=VBA+Error+13+OR+%22Type+mismatch%22&gws_rd=ssl

If that gets you nowhere, suggest you use a specialist excel forum e.g. MrExcel.com https://www.mrexcel.com/forum/index.php

 

[Gasman]

Excel Runtime Error 13 appears to be Type mismatch error?

Open Excel and then open the file from within Excel holding the shift key down until it loads then investigate the code.

HTH

 

[amans15877]

You can use the following steps to help you tackle any Type mismatch error.

Run the code so that the error appears.
1. Click Debug on the error dialog.
2. Select View->Watch
3. Highlight the variable to the left of the equals and drag it into the Watch window.
4. Highlight everything to the right of the equals and drag it into the Watch window.
5. Check the values.