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!! |
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 |
All times are GMT +1. The time now is 05:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com