P philiphales New Member Jan 24, 2021 #1 can anyone help, I need to sum random cells on a spreadsheet by colour, which updates as I change the colours
can anyone help, I need to sum random cells on a spreadsheet by colour, which updates as I change the colours
V vletm Excel Ninja Jan 24, 2021 #2 philiphales Have You tried to search ( top right corner ) from this Forum?
H Hany ali Active Member Jan 25, 2021 #4 ok ... How to wait Helping or Reply to You without Upload asmall Simple ?!!! Upload please Excel File for You Want
ok ... How to wait Helping or Reply to You without Upload asmall Simple ?!!! Upload please Excel File for You Want
P philiphales New Member Jan 25, 2021 #5 I found something,but when I cut and pasted it said:- A module is not a valid type
P philiphales New Member Jan 25, 2021 #6 Hany ali said: ok ... How to wait Helping or Reply to You without Upload asmall Simple ?!!! Upload please Excel File for You Want Click to expand... Hi I prepared this for you from the VBA I found and for some reason it now works, but is there a way of making it automatically recalc should I change some of the colours? As it is I have to remember to press CTRL ALT F9 Thank You Attachments Sum Cells By Colour Download.xlsm 82.9 KB Views: 10
Hany ali said: ok ... How to wait Helping or Reply to You without Upload asmall Simple ?!!! Upload please Excel File for You Want Click to expand... Hi I prepared this for you from the VBA I found and for some reason it now works, but is there a way of making it automatically recalc should I change some of the colours? As it is I have to remember to press CTRL ALT F9 Thank You
P p45cal Well-Known Member Jan 27, 2021 #7 Try adding the line: Application.Volatile before or after the Dim statements in your SumByColor function code.
Try adding the line: Application.Volatile before or after the Dim statements in your SumByColor function code.