F9 not working with SumByColor

[tinybluestars]

I am using the SumByColor function found at this website:
http://www.exceltip.com/st/Sum_by_color_using_VBA_in_Microsoft_Excel/517.html

Everything is working with the initial input of information, but when
I change color information I haven't been able to force a calculation,
I have tried all combinations of F9 and none have worked. Any
suggestions?

 

[Jim Thomlinson]

Change of colour does not dirty any cells requiring them to recalculate. Have
you tried (Shift + Ctrl + Alt + F9). That is a full calculations of all cells
whether they are dirty or not.

 

[tinybluestars]

Jim,

Thank you, but yes I have attempted all combinations of F9.

 

[Peter T]

I think just Ctrl + Alt +F9 should do the job. Or add +Now()*0 to end of
the formula and simply F9 should work.

In passing, the OP's link to that sum by color function is not so well
written, I think Chip Pearson and/or Bob Phillips may have something much
better.

Regards,
Peter T

 

[tinybluestars]

Peter,

Thank you, but f9 is not working.