HI,
I have a worksheet that sums up cells based on if they have been shaded any color.
I managed to write a function that acheives this, however I did have to hit f9 every time any of the cells were changed to recalculate the totals.

I got around this by putting me.calculate in the change event of the sheet.
The issue I have no is that when you select copy, then move to another cell it forces the calculation and you loose the data you copied, which just shows as paste being greyed out.

How do I update the calculatons when a change is made, but still have the ability for users to copy and paste within the worksheets.