Hi Ste_Mulv.
1) A macro to remove formulas from any/all cells currently selected. This will work if one cell is selected, a range cellls, or random non-contiguous cells, it will still work. No matter how many cells are selected, it will ask for permission (and name the cells) to do it.
Install the macro:
A. Open up your workbook
B. Get into VB Editor (Press Alt+F11)
C. Insert a new module (Insert > Module)
D. Copy and Paste in your code (given above)
E. Get out of VBA (Press Alt+Q)
F. Save your sheet
The macro is installed and ready to use. You can press Alt-F8 and select it from the macro list, or:
========
2) Add a button to your sheet for the macro.
A) Make sure the Forms Toolbar is visible.
B) Click on the Button icon
C) Draw your button on your sheet
D) The Assign Macro window will appear...select the RemoveFormula macro we added earlier
E) Click OK
F) Click on the button text and change the caption to whatever you wish it to be.
G) Click on a blank cell to unhighlight the button (this makes it active)
========
You can now select as many cells/ranges you want, then click your macro button.
Bookmarks