type mismatch 13 in excel 2010

The following code worked perfectly under excel 2003, but in 2010 returns error 'type mismatch 13' in the following line "If Array2(1, i) <> 0 Then"

Anyone has any ideas how to solve this ?

Thx in advance

Sonny

Here is the code:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. I have added code tags for you because you are a new member, see rule #3. --6StringJazzer

Did you run the code step by step with F8 ? attach please a sample file for testing

Type mismatch sounds like you are trying to do some math function with a string in the array variable, or vice versa.

I agree with patel, you should step through your code and see what is in that variable before it gives the error.

http://www.cpearson.com/Excel/DebuggingVBA.aspx

Perhaps you have error values in your sheet.