Excel formula updating
I've found the following bit of code online, to add a =countccoolor function to excel, which counts the number of cells in a range that have a certain color.The range is the "A" column, and I color whole rows based on case status.I set a formula to an entire column but it does not take affect unless I double click in each of the boxes? It does not do it unless i double click in each specific one.
Whatever criteria you use in your head to choose whether a cell is colored or not can probably be used as a criteria in a countif(s) type of function. I reread the part about putting the code "on the right worksheet module" and after trying all permutations, found one that did the trick.Public Sub Update My Functions() Dim my Range As Range Dim rng As Range ' Assume the functions are in this range A1: B10. Formula Next End Sub Public Sub Update My Functions() Dim my Range As Range Dim rng As Range 'Considering The Functions are in Range A1: B10 Set my Range = Active Sheet. When you press F2 and Enter you are, effectively, changing a cell so Excel re-calculates.You might get away with pressing F9 to calculate Regards, TMS Trevor Shuttleworth - Excel Aid I dream of a better world where chickens can cross the road without having their motives questioned 'Being unapologetic means never having to say you're sorry' John Cooper Clarke You can probably call the function on a Selection_Change event.. Volatile might not work because the sheet does not re-calculate when the color is applied..
The apostrophe will not be visible in the cell on the spreadsheet, but you can see it in the Formula Bar.