Clearing formulas

[Eric]

Hello all,

Is there a way to save a worksheet and at the same time delete a formula
from a certain cell?

IE:
Cell P1 has a formula +If(Ag101=1,AG100,AG99)

AG99= 12 AG100= 15 AG101=1

Cell P1=15

When I save this sheet I want the information in P1 to stay but the formula
to be gone. So when I pull up the sheet again in cell P1 the information is
there but no formula. Is this possible?

ERic

 

[Neily]

You could valuecopy the cell and save it at the same time.

Something along the lines of...

Sub SaveMyFile

Range("P1").Copy
Range("P1").PasteSpecial xlValues
ThisWorkbook.Save