I need to create a button that allows me to clear data but not formulas for certain cells

**all4ever15** · 12-12-2017, 12:43 PM

Hey all!
I'm about to chuck my computer so any help would be appreciated. I need to clear data from a cell but keep the formulas. This is a spreadsheet that will be used over and over with different data each time. I need to keep all formulas but clear the data. I need to do this in just a selected range of cells.

I tried to record a macro where I go to find & Select >Go to special>Constants> Unclick Logicals and errors>OK>Delete. I then assign this recorded macro to a button. When I click the button nothing happens. Any other ideas??

**Mumps1** · 12-12-2017, 12:49 PM

On Error Resume Next
Range("A1:A10").SpecialCells(xlCellTypeConstants).ClearContents

Change the range to suit your needs.

I need to create a button that allows me to clear data but not formulas for certain cells

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

I need to create a button that allows me to clear data but not formulas for certain cells

Re: I need to create a button that allows me to clear data but not formulas for certain ce

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to create a macro button to clear muliple cells on multiple worksheets

[SOLVED] create a 'button' to click to clear cells

[SOLVED] Button to insert new row, clear data and keep formulas

How to make buttons to select certain cells and then click on a button to clear data?

Create a button to clear data in certain cells

create a clear button

[SOLVED] Create a button to Clear Cells

Bookmarks

Bookmarks

Posting Permissions