|
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 |
Clearing formulas
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 |
| All times are GMT +1. The time now is 02:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com