Removing All Formulae From a Workbook
 

Is it possible to remove all formulae from an entire workbook and leave
the values behind using VBA?


--
Papa Waigo
------------------------------------------------------------------------
Papa Waigo's Profile: http://www.excelforum.com/member.php...o&userid=36074
View this thread: http://www.excelforum.com/showthread...hreadid=558672

Removing All Formulae From a Workbook
 

Switch the macro recorder on and

CRTL+A (select all)
CTRL+C (Copy)
EditPaste Special, check Values

Switch the macro recorder off and look at the code

--
Kind regards,

Niek Otten


"Papa Waigo" wrote in message
...
|
| Is it possible to remove all formulae from an entire workbook and leave
| the values behind using VBA?
|
|
| --
| Papa Waigo
| ------------------------------------------------------------------------
| Papa Waigo's Profile: http://www.excelforum.com/member.php...o&userid=36074
| View this thread: http://www.excelforum.com/showthread...hreadid=558672
|