Delete values and preserve formulae

[Stuart]

I've made manual alterations to a Summary sheet, in the form
of inserting formulae. The sheet is worked on by an addin.
The alterations are to cells NOT operated on by the addin.

Say the range containing new formulae is M154.
How do I clear values in this range, but preserve the new
formulae, before saving the sheet back to the original file?

My idea is that the addin will run as normal, and produce the
Summary sheet. However, for certain files, the Summary
sheet will contain additional formulae which will take the
values computed by the addin and do other things.

Regards.

 

[Dave Peterson]

You can select M154
then Edit|goto|Special
choose Constants

And hit the delete key.

Hit Edit|Undo if that's not what you meant.