| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically update macro
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically update macro
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update graphs | Charts and Charting in Excel | |||
| Automatically update cell value | Excel Discussion (Misc queries) | |||
| Automatically update a 2 lists | Excel Discussion (Misc queries) | |||
| Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
| Links update automatically | Excel Discussion (Misc queries) | |||
Linear Mode
