Remove formula and keed data using VBA

[Guest]

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

Thanks, Danny

 

[George Nicholson]

Same as you would manually: Copy>PasteSpecial:Values

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

HTH,

 

[Bob Phillips]

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)