Remove formula and keed data using VBA
 

I want to remove formulas from certain cells but leave the data. How can I do
that using VBA?

Thanks, Danny

Remove formula and keed data using VBA
 

Same as you would manually: CopyPasteSpecial:Values

Turn on the Macro recorder, do it manually, turn off the recorder and adjust
the resulting code for your situation.

HTH,


"Danny Crowell" wrote in message
...
I want to remove formulas from certain cells but leave the data. How can I
do
that using VBA?

Thanks, Danny

Remove formula and keed data using VBA
 

For Each cell In Selection
cell.Value = cell.Value
Next cell

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danny Crowell" wrote in message
...
I want to remove formulas from certain cells but leave the data. How can I
do
that using VBA?

Thanks, Danny