Count red values from certain companies

Please Login or Register  to view this content.

I use this code to count red cells from a certain company
It works although it only seems to count the first row in my range

There must be a way to continue onto the next row!
Please help

Example:

Formula:

Please Login or Register  to view this content.

Hi,

I think the problem is with parameters that you used in .Cells() method. It will be easier for me to give you the exact answer with a sample file. Could you please post it?

Regards,
Alex

samplefile.xlsm

I have attached a sample file
Thanks for your help!

OK. I think I've made it Here is the code:

Please Login or Register  to view this content.

And here is your sample file to test the macro.

samplefile_s1.xlsm

When you change a color of values, you need to press F9 button to recalculate function's results (I couldn't manage to avoid that).

Regards,
Alex

Thanks Alex

Although every time I try this on my original workbook it freezes

It's weird. You might try to comment out a line with "Application.Volatile". Maybe it causes the freezing.

Please try this code:

Please Login or Register  to view this content.

Is your workbook freezing with sample data or the actual one?