Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove $ from formulas | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming | |||
remove formulas | Excel Discussion (Misc queries) | |||
Is there a way to remove numbers w/o remove formulas | Excel Programming |