VBA code for Count if funtion for entire workbook

Hi,

You can use the below formula to get cells with value "general" in E column in a worksheet.

Please Login or Register  to view this content.

Regards,
Paresh J

Hi,

Check the below code and hope this is what you want:

Please Login or Register  to view this content.

Regards,
Paresh J

Hi,

What exactly is your requirement? Do you want count of word "general" individually on each sheet / as total on one sheet? What is sheet name must contain SQI? Is it that sheet names with SQI should only be checked for counting?


Regards,
Paresh J

Hi,

You can use the below code to get total count of word "general" from all sheets which contains SQI in their sheet names.

Put the below code in ThisWorkbook.

Please Login or Register  to view this content.

Note: If you dont want SQI contains part, you can comment out the IF part in the code.

Regards,
Paresh J

Hi,

Check out the below code, it gives result as expected by you. Please check the cell F1 of each sheet for the count.

Note: Please paste the below code in the ThisWorkBook section.

Please Login or Register  to view this content.

Regards,
Paresh J

Originally Posted by pareshj

Hi,

Check out the below code, it gives result as expected by you. Please check the cell F1 of each sheet for the count.

Note: Please paste the below code in the ThisWorkBook section.

.........

Regards,
Paresh J

Hi Paresh,
Wouldn't the code go into a regular module?
Is it a workbook_event code?