automatically update macro

C

Cheryl L

I have a macro that counts the number of cells with a specific color and
totals the number in a separate cell. How can I get the totals to
automatically update when I change the color of a cell?

Thanks in advance!!
 
D

Dave Peterson

You can't.

Excel doesn't recalculate when a color changes.

You either have to force excel to recalc (F9) or wait until xl recalculates.
 
Top