Loop through 2 sheets

Please Login or Register  to view this content.

Without the loop for the sheets, it works out fine, and in sheet 3 is shown the results of the CountIf.
With the loop, all the results are 0.
Any idea what the problem is?

You're giving us the minimum information possible. What are you trying to do? What are the variables? Is this line a typo?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

typo indeed.
Well, not a lot more of information is required.
for example, I'm counting all the people named JEF in sheet 1 and 2.
In sheet 3 you can see the results.
So, I tried this For Next, to loop through the two sheets, but the results are 0.

Please Login or Register  to view this content.

But, if I do it without the loop for worksheets. It works perfectly, the negative point is that my code is twice as long.

Try referencing the sheet directly

Please Login or Register  to view this content.

and remove the Select line. I still can't follow your code - you should define your variables.

Also, since you're asking a question here don't you think we should be the judge of how much information is needed?

Please Login or Register  to view this content.

This works, the right results are showed

Please Login or Register  to view this content.

This doesn't work, all the results are 0

I hope this is enough information

Repeatedly posting the same code is not information. Post a workbook. I don't see why you can't use formulae anyway.