Runtime Error 13 Type Mismatch on one computer, but not another

Hi all,

I have a macro in a spreadsheet that is running 100% fine on a Windows 7 computer.

However, when I tried running it on a different computer (That used to be windows 8, but has been updated to windows 10)

I get this error:
Runtime Error 13 Type Mismatch

I tried running office safe mode (Holding ctrl+double clicking excel shortcut to launch it), but got the same error when I ran the macro?

Since the error is not in the code, what do I do to fix it on my new machine?

Thanks!

.
If the code generates an error, the offending line of code will be highlighted in yellow.

If you cannot see a yellow highlighted line of code, place this phrase at the top of your Macro : OPTION EXPLICIT

That should point out the offending line.


The error you are seeing indicates a variable has been DIM (dimmed) but you are using the wrong type. One example: Dim i As String when it should have been Dim i As Integer