replacing cell references with the actual values they refer to

[Takeadoe]

Hi folks,

After perusing the topics in this group, I'm sure this will be an easy
one for someone. I have a large number of cells that contain numeric
values from cells in other worksheets. I would like to replace the
reference with the actual values being displayed in the cells. In
other words, eliminate any references to other cells with the values in
the cells. I suppose it would be like a cut and paste special - paste
values - operation. I suppose this is what I should have done in the
first place. The problem is I have 88 worksheets and I don't want to go
through all the cut and paste routines again. Does that make sense?


Mike

 

[Don Guillett]

try
range("a2:x22").value=range("a2:x22").value

 

[Takeadoe]

Hi Don,

I'm not sure I follow you. Could you please elaborate some? I
appreciate your help.

Mike

 

[Don Guillett]

This is a macro that turns the formulas in the desired range into just the
values.
=a1*3 assuming a1 contains 3 becomes 9 without the underlying formula.