| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing formulas
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
| clearing data but retaining formulas | Excel Discussion (Misc queries) | |||
| Clear a worksheet without clearing formulas? | Excel Discussion (Misc queries) | |||
| Clearing all values in range that aren't formulas | Excel Programming | |||
| Clearing Contents but not Formulas | Excel Worksheet Functions | |||
Threaded Mode
