Select the range, press F5, select constants, press enter, delete or
editclearcontents


Regards,

Peo Sjoblom

"Louise" wrote:

Hi all

Does anybody know if it is possible to select a worksheet and delete the
contents but leave the formulas alone?

Thank you.

Louise