Runtime error 13 - type mismatch

Hello,

I have a VBA code that run for a set of data(all in numbers). The code is totally fine when it is run for the first time. But when I run it again, the error - "type mismatch" will come out. When I open a new excel workbook and paste all the data and code into it, it works at the first time. But the error will pop up again if i run for the second time. Can anyone help to solve?
Thanks a lot for the help!

My code is as below: (the red line is where the error message pop out)

Please Login or Register  to view this content.

Hi,

Possibly try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

or simply just 0 (if you are multiplying by 0, you may as well skip the multiplication step...).

My hopes aren't high for this as a solution, but if it doesn't work please upload your workbook (or a usable sample) so that I can debug the code in its original context.

Thanks

Your purpose in multiplying by zero is unclear. Seems either to produce a zero, in which case you'd be better doing that directly, or to check if any non-numbers occur in your data.

A cause for type mismatch error is trying to multiply a non-number (other than a blank) by a number (including zero).

Track it down a bit more by replacing your red line by

Please Login or Register  to view this content.