| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Formulae Across a Workbook | Excel Discussion (Misc queries) | |||
| Removing all formulae/functions/codes from previously saved worksh | Excel Discussion (Misc queries) | |||
| Destination workbook formulae become #VALUE! | Excel Discussion (Misc queries) | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| Vba - Removing workbook | Excel Programming | |||
![Papa Waigo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
