I Need a Macro Clear Button

[samsilverman]

I am using Excel 2007.

We have a Database in Excel 2007 (at least that's what I call it ). It's used in the field to input ventilation and chemical exposure readings.

One sheet we use is named Generic Ventilation. Is there a way to create a macro button (that would not show up on the printed report) that would clear whatever cells I wanted to clear while leaving other cells alone?

If I get a solution, I would want to be able to customize it for a couple other sheets we use that have different cells needing to be cleared or retained.

Thanks for any assistance anyone can give. Please keep in mind I am a rookie. Thanks again.

 

[RPK111]

Send me a PM with an e-mail address I send a file to and I will create a real simple spreadsheet with a button that will clear some cells values. You can then change the code to clear the specific cells you need it to.