run type error type 13

[Gti182]

Hi guys,

getting a run type error type 13 and not really understanding why.

This is the portion of code which throws up the debugger. Its basically part of a macro which compares two sheets of data and highlights any differences in red. It worked perfectly last month but some data this month has caused it to now work

Please Login or Register  to view this content.

[Andy Pope]

Any of those cells contain an error such as #DIV/0! or #VALUE! ?

[Gti182]

Hi andy pope, no errors that i can see. There are N/A# values but this isn't causing the error

[Andy Pope]

Are you sure?

When read into the array #N/A! will be stored as 'Error 2042' which in turn causes the Error Type 13.

[Gti182]

I have some new information which may help this.

I've noticed that if there are any values in columns X,Y or Z that are the value ZERO then i get the Type 13 error. If they are N/A or a positive number the code runs perfectly.

Not sure why the value zero would cause any problems here?? Is there something i can modify in the code to account for this?

[Andy Pope]

without seeing actual data only thing to suggest is that just check contents of each array item as being valid before comparing with others.