PC Review


Reply
Thread Tools Rate Thread

Clearing formulas

 
 
Eric
Guest
Posts: n/a
 
      13th Feb 2008
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
 
Reply With Quote
 
 
 
 
Neily
Guest
Posts: n/a
 
      13th Feb 2008
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clearing cells without clearing formulas marsjune68 Microsoft Excel Misc 2 10th Apr 2009 07:39 PM
clearing data but retaining formulas pm Microsoft Excel Misc 10 26th Jan 2008 01:37 AM
clearing data but not formulas pingu_632@hotmail.com Microsoft Excel Discussion 4 18th May 2007 09:21 PM
Clearing Contents but not Formulas =?Utf-8?B?TG91aXNl?= Microsoft Excel Worksheet Functions 6 27th Jan 2005 05:04 PM
Clearing cells with formulas Dan Wilson Microsoft Excel Worksheet Functions 1 25th Jul 2004 09:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:05 PM.