View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default Removing Links and Formulas

Excel 2003. I have workbooks in which there are internal links (cell
formulas and references to labeled cells in other sheets). I would like to
"freeze" these before programmatically copying these sheets to another
workbook. How can I resolve the internal links and formulas so that the
references and formulas are no longer there, only the actual values the
references or formulas produce? I need to do this programmatically. Thanks
for the help and God bless.

--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org