Hi,

I have written code on several worksheets that counts the number of cells that are NOT shaded with color. Took me forever, but it is working great.

When the user changes the colors of cells my formula wouldnt automatically calculate, so I added the me.calculate function to each worksheets On_Change event.

Today we discovered we cannot copy and paste within the workbook...each time you select copy, and move to a different place in the workbook it triggers the calculate command and the data you selected to copy is not available to paste (Paste is greyed out).

I went back and removed the me.calculate function and my copy and paste returned to normal, but now when you make changes to cells the formulas wont update automatically.

Any solutions on how to have both would be so greatly appreciated.

Thanks you!