convert formulas to values in place

[K. Georgiadis]

I know how to convert formulas to values by copying to
another sheet with Paste Special. Is there a way to
change the formulas to values in place, without having to
copy the data to another sheet? I have a data table
created by pointing to cells in different parts of the
workbook. I am trying to create a "static" table that
does not get updated with changes in the source data
(why? you may ask, but that is a long story)

 

[AlfD]

Hi!

Yes.

Copy the data.
Keep the same selected cells (i.e. don't click any other cell).
Choose Paste Special: select Values: OK.

Obviously, the formulae are then gone for ever (apart from being able
to use Undo at that point).

Alf

 

[Peo Sjoblom]

Jus paste as values in place

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Don Guillett]

activecell.formula=activecell.value