I currently have to copy the formula down all the rows and then over all
the columns to get the values. I then copy all the cells and
paste-special-values. The reason I don't keep the formula in all the
cells addresses the following two issues:

1) People will change the value when doing custom scenarios (I know
about the scenario function of Excel, but must users will not) and
could potentially need to return that cell to the original value.

2) I am using a long SUMPRODUCT function to lookup the data. Having
50k-100k SUMPRODUCT calls slows the computer down considerably.

So, being able to highlight the cells and running a macro to insert the
value the formula (not the formula itself) would be ideal.


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=379833