Remove Formulas, Keep Values
 

Hi all,

I'm putting together a spreadsheet that is using the INDIRECT function
to link to a number of other spreadsheets. The problem with this is
that the link only works when the other spreadsheets are open.

What I'd like to do is, once I've put together my report, to have a
macro that removes formulas, but keeps the values - hence, others can
read it without having to have the 15+ supporting spreadsheets open.

Any ideas?

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=482777

Remove Formulas, Keep Values
 

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SamuelT" wrote in
message ...

Hi all,

I'm putting together a spreadsheet that is using the INDIRECT function
to link to a number of other spreadsheets. The problem with this is
that the link only works when the other spreadsheets are open.

What I'd like to do is, once I've put together my report, to have a
macro that removes formulas, but keeps the values - hence, others can
read it without having to have the 15+ supporting spreadsheets open.

Any ideas?

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=482777

Remove Formulas, Keep Values
 

Just select the cells, Copy, EditPasteSpecial and select Values.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SamuelT" wrote in
message ...

Hi all,

I'm putting together a spreadsheet that is using the INDIRECT function
to link to a number of other spreadsheets. The problem with this is
that the link only works when the other spreadsheets are open.

What I'd like to do is, once I've put together my report, to have a
macro that removes formulas, but keeps the values - hence, others can
read it without having to have the 15+ supporting spreadsheets open.

Any ideas?

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=482777

Remove Formulas, Keep Values
 

On Mon, 7 Nov 2005 06:10:51 -0600, SamuelT
wrote:


Hi all,

I'm putting together a spreadsheet that is using the INDIRECT function
to link to a number of other spreadsheets. The problem with this is
that the link only works when the other spreadsheets are open.

What I'd like to do is, once I've put together my report, to have a
macro that removes formulas, but keeps the values - hence, others can
read it without having to have the 15+ supporting spreadsheets open.

Any ideas?

TIA,

SamuelT

Something like:
-----------------------
Sub foo()
dim c as range

for each c in range("where your formulas are")
c.value = c.value
next c

end sub
-----------------


--ron