Writing a Macro to Clear Contents of an Excel Spreadsheet

[wfairbanks]

I am trying to write a Macro to Clear the contents of a range on an excel spreadsheet. Any help would be greatly appreciated.

Thanks,
Wendy

 

[mike136]

If your clearing all data try :
Range("your data area&quot.Select
Selection.ClearContents

 

[wfairbanks]

Would you put this code in a command button?

 

[Acquaman]

Dear Wendy,
On the Tools drop down, select Macro, Record New Macro. Fill in the activation letter (Ctrl a - z) give it a description in the bottom field, then press Record. At that point, any actions you make with the mouse and key board are being recorded. Clear the fiels you want cleard or if you want all but cell boarders cleared, click the upper left hand block of the sheet (above 1, next to A) right click, click Clear Contents, click any cell (to remove highlighting), re-enable protection and, click Stop Recording. Now everytime you want to clear the sheet, just hold down the Ctrl button and press the activation letter that you chose before starting the macro Recording.
Hope that this helps...EdAcquaro@aol.com if I can be of any more service to you.