Counting cells that are non matching

[NWEdison]

Hello,

I am trying to come up with a way to sum the total of non matching cells when comparing two columns in two workbooks. So far I have the following, but I am bit confused as to what to do next:

Please Login or Register  to view this content.

With Range"A8" being the resultant cell.

[Leith Ross]

Hello NWEdison,

Welcome to the forum!

Here is one to do it...

Please Login or Register  to view this content.

[NWEdison]

Hey thanks!

So the following happens: If I leave the code as is and add your part to it, I get an error saying "or Control Variable in Use". Do I need to remove the Irow/Icol string after the else statement or can I add the entire string?

[NWEdison]

And here is the complete code. It debugs and runs without error, but it does not give me an resultant to the target cell.

Please Login or Register  to view this content.

[Leith Ross]

Hello NWEdison,

Sorry for the confusion. The code I posted replaces all of the code you have now...

Please Login or Register  to view this content.

[NWEdison]

Hey,

So I ran your code and it did not work. Is it because we aren't activating the worksheets before running it? Like so:

Please Login or Register  to view this content.

and even that code doesn't work? I am a bit confused.