Copying CONTENTS not Formulas

Giganews Newsgroups
Subject: Copying CONTENTS not Formulas
Posted by:  ArenaNinja (
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's Profile:
View this thread: