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