countif in the last 5 sheets

[aishaz_88]

Hi

I have a workbook that has 20 sheets.
I need to count the number of 2 in column A of the last 5 sheets.
Bearing in mind that whenever i run the macro the page name may change.

here is what i have to do before counting the number of 2's in column A:

Please Login or Register  to view this content.

so can any1 help?

thank you very much. You rhelp is much appreciated.

[jindon]

Please Login or Register  to view this content.

[aishaz_88]

thank you so much
i would like to know how do you know what VBA codes to input when you want to count or something?.

is there any tutorial that i can read up?

Thank you very much