automatically update macro

's Computer Specifications

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!!

's Computer Specifications

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.

Cheryl L wrote:
>
> 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!!

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a macro be automatically run after an update from MS query?	AndyT	Microsoft Excel Misc	4	7th Nov 2008 03:27 PM
macro to automatically update dates	Cheryl	Microsoft Excel Worksheet Functions	1	14th Aug 2008 11:14 PM
Macro to Create a Chart and Update it Automatically	=?Utf-8?B?bWFwZXJhbGlh?=	Microsoft Excel Charting	2	21st Oct 2005 05:42 PM
How can I automatically update T/F Control using Access Macro	=?Utf-8?B?S0tL?=	Microsoft Access Macros	2	8th Sep 2005 09:48 AM
How do I set up a macro to automatically update links upon openin.	=?Utf-8?B?TWlrZUpveW5lcg==?=	Microsoft Excel Programming	1	6th Jan 2005 07:43 PM