Clearing formulas

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to grab a reference into VB 2
Function in a VBA prog. or something like that 4
formula trouble 2
UDF returns #NUM! with F9 or Application.CalculateFull if sheet notactive 11
VBA Function returns #VALUE! when working on another book 2
Countif formula perhaps 7
Need help on this strange event 1
Not a programmer...am I in over my head?? 9

Back
Top