Copying CONTENTS not Formulas

Giganews Newsgroups
Subject: Copying CONTENTS not Formulas
Posted by:  ArenaNinja (ArenaNinja.27z3sb_1147905304.5045@excelforum-nospam.com)
Date: Wed, 17 May 2006

I need to transpose some information from a workbook to a new workbook,
which will contain summaries of many different notebooks. How do I copy
the CONTENTS of all cells in a workbook, without taking the formulas?
(i.e.: if R28 is "=SUM(R4:R27)" and the result is 512, I want Excel to
post 512, NOT the formula.

--
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=33624
View this thread:http://www.excelforum.com/showthread.php?threadid=543114

Replies