Removing macro's once data is in place

Noir · Mar 25th, 2002, 10:45 AM

Is there a way to remove a formula from a cell without removing the data the formula installed? Once i have the data in each cell, the formula is no longer needed.

Thanks,
Noir

Tom Schreiner · Mar 25th, 2002, 11:21 AM

This should do the trick!

Formula in sheet1 A1
Sheet1.Range("A1").Copy
Sheet1.Range("A1").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Have a nice day!

Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 10:45 AM	#1
Noir Board Regular Join Date: Mar 2002 Posts: 364	Is there a way to remove a formula from a cell without removing the data the formula installed? Once i have the data in each cell, the formula is no longer needed. Thanks, Noir

Mar 25th, 2002, 11:21 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	This should do the trick! Formula in sheet1 A1 Sheet1.Range("A1").Copy Sheet1.Range("A1").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Have a nice day! Tom