Thread: countcolor
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pascal Pascal is offline
external usenet poster
 
Posts: 1
Default countcolor

Hi, I'm using this Macro in VBA to get excel calculate every cell that
has a particular BG color in a determided range:

http://www.cpearson.com/excel/colors.htm
Counting Cells With A Specific Color

Does someone know how to modify this function so that it automatically
triggers a recalculation right after i modify a cell's bg color?
Because right now, I have to force it manually clicking on CTRL+ALT+F9.

Thanks a lot!

Pascal