Protect Formulas

[parteegolfer]

Is there a way to protect formulas from being deleted when clearing cell from current data?

[Paul B]

parteegolfer, one way select the range you want to clear, then edit goto
special, select constants, Ok, delete

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"parteegolfer" <[email protected]>
wrote in message
news:[email protected]...
>
> Is there a way to protect formulas from being deleted when clearing cell
> from current data?
>
>
> --
> parteegolfer
> ------------------------------------------------------------------------
> parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
> View this thread: http://www.excelforum.com/showthread...hreadid=526260
>