| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
F9 not working with SumByColor
I am using the SumByColor function found at this website:
http://www.exceltip.com/st/Sum_by_co...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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
F9 not working with SumByColor
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. -- HTH... Jim Thomlinson " wrote: I am using the SumByColor function found at this website: http://www.exceltip.com/st/Sum_by_co...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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
F9 not working with SumByColor
Jim,
Thank you, but yes I have attempted all combinations of F9. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
F9 not working with SumByColor
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 "Jim Thomlinson" wrote in message ... 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. -- HTH... Jim Thomlinson " wrote: I am using the SumByColor function found at this website: http://www.exceltip.com/st/Sum_by_co...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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
F9 not working with SumByColor
Peter,
Thank you, but f9 is not working. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumByColor & #NAME? | Excel Worksheet Functions | |||
| SumByColor Stopped Working | Excel Worksheet Functions | |||
| SumByColor(Rng) | Excel Programming | |||
| how to use sumbycolor fuction? | Excel Worksheet Functions | |||
| SumByColor Macro... | Excel Programming | |||
Linear Mode
