or...

can is there a way to have a macro do the following?

if any cell c5 thru r20 contains data, then copy and paste the value in the
cell.

this would remove the cell calculation for that day.. on monday the forum
would be black but on friday it should be full... just a though...

maybe using the for,next command?