Saitej1234
New Member
>>> use code - tags <<<
The above function is not updating the calculation automatically when i change the color of cell .but it is updating when i press f9.please help me to autoupdate when ever i change the color without Pressing f9.
Code:
Function Sumcolor(cellcolor as Range, rRange as Range)
Application.volatile
Dim csum as double
Dim colindex as integer
Colindex = cellcolor.interior.colorindex
For each cl in Range
If cl.interior.colorindex = colindex then
Csum = worksheetfunction.sum(cl, csum)
End if
Next cl
Sumcolor = csum
End function
The above function is not updating the calculation automatically when i change the color of cell .but it is updating when i press f9.please help me to autoupdate when ever i change the color without Pressing f9.
Last edited by a moderator: