Runtime error'13' - type mismatch

Hi,

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

My code is as below: (the red words indicate where the error comes from)

Please Login or Register  to view this content.

Hello Polluz,

Moderation removed.

Thank you for adding the "Code Tags".

Regards.