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

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

"Eric" wrote:

> 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