count of multiple sheets

[aishaz_88]

Hi

hope someone can help me

i have a workbook that has 31 sheets plus 1 results sheet

i need to count the non-blanks for column A of all the sheets except for the results page.

and then the total will be displayed in cell A2 of the results page..help please

[antoka05]

Try to use this code:

Please Login or Register  to view this content.

Regards,
Antonio

[aishaz_88]

this works great!!

you saved my life..haha

thank you a lot