Loop through 2 sheets

[Treuz]

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?

[StephenR]

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.

[Treuz]

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.

[StephenR]

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?

[Treuz]

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

[StephenR]

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