"Refresh" custom function in cell with a macro

[ciresuark]

I am using the following functions together to get an average of colored cells.

Please Login or Register  to view this content.

I am using:

Please Login or Register  to view this content.

to change the cell color to the desired color and I would like it to "refresh" the formulas in Range(A14:M14). I have tried Calculate and CalculateRowMajorOrder. CalculateRowMajorOrder changed the values the first time but when I tried on a different cell it didn't update again. Thoughts on how to make this work?

[ciresuark]

I was able to get it figured out.

Please Login or Register  to view this content.

It replaces all the '=' in the activesheet with '=' thereby forcing a recalculation.

Thank you to all who looked