Create a button to clear data in certain cells

**headbanger51** · 01-05-2008, 05:30 PM

I have several sheets where you fill in the same cells with data which needs to be cleared. Is there a button I can create to clear the data in a select group of cells so I don't have to manually click and delete each input cell? Thanks!
- John

**shg** · 01-05-2008, 05:42 PM

Cross-post: http://www.ozgrid.com/forum/showthread.php?t=82529

**VBA Noob** · 01-06-2008, 03:15 PM

Reopened. headbanger51 has agreed to the rules.

headbanger51,

What are the cells on each sht. Are there any sheets to ignore

VBA Noob

**headbanger51** · 01-06-2008, 03:21 PM

There are several sheets and I would want to program the button to clear only the data on that particular sheet. There are a total of four sheets that I would like to have their individual button programmed for. The sheets are also protected so that the only data that can be entered is in the certain select cells...the ones I want the button to "refresh" or clear. I can include one of the sheets if that will help. Thanks!
- John

**VBA Noob** · 01-06-2008, 03:23 PM

What are the cells

Still need to confirm the range. Is it a block of cells or individual cells

VBA Noob

**headbanger51** · 01-06-2008, 03:33 PM

Oh, sorry...they are indivdual cells. I've included one sheet as an example. The cells shaded in light yellow are the input cells that I would like cleared from a button.
- John