I don't believe you can clear contents without deleting the formula. Because
clearing contents is exactly that, clearing contents. You will have to get a
little creative to do this.

1.) You can write code to change the text color to match the interior color
of the cell, thus it would hide the cell value.

2.) You could embed your formula in a IF formula. For example, you could
put this forumla into a cell "=IF(C1=TRUE,SUM(A1:A10),"")". This formula
will make the cell appear blank if C1 doesn't have the word "TRUE" in it.

Are you wanting to do this for all formulas in a worksheet, workbook, or
some sheets?

When do you want to "clear contents"? When a user prints, opens the workbook?

Hope this helps! If so, let me know, click 'YES" below.
--
Cheers,
Ryan


"djh" wrote:

How can I clear the results of a formula from a cell without deleting the
formula itself?