Hi Louise

you're welcome and thanks for the feedback

Cheers
JulieD

"Louise" wrote in message
...
Hi

Thanks very much. It worked a treat.

Louise

"JulieD" wrote:

Hi Louise

choose your worksheet then choose
edit / go to click on the special button
choose constants
you have some tick boxes you can play with, then press OK
now press the delete key.

hope this helps
Cheers
JulieD
PS please backup your workbook before trying this.

"Louise" wrote in message
...
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