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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Takeadoe" <mtonkovich@msn.com> wrote in message
news:1139270120.392343.6090@g47g2000cwa.googlegroups.com...
> 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
>

[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.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Takeadoe" <mtonkovich@msn.com> wrote in message
news:1139359536.613991.251420@g14g2000cwa.googlegroups.com...
> Hi Don,
>
> I'm not sure I follow you. Could you please elaborate some? I
> appreciate your help.
>
> Mike
>