Copy the range, then in place EditPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 11:12:01 -0800, jmomorrison
wrote:

Yes, that's what I would like to do, but how please?

Thanks

"Gary''s Student" wrote:

Either freeze the inputs or place the formulae with values.
--
Gary's Student


"jmomorrison" wrote:

I have an array formula that matches product codes on the active worksheet to
corresponding product costs in another workbook. For inventory purposes, I
want the formula to return the total value of the product at the time I make
the entries. That is working fine. My question is, how can I then freeze
those values, so that if the product cost changes in the future, it won't
affect my past inventory amounts?

Thanks!