MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Clearing Cells


Posted by Stan Kaye on February 14, 2002 8:10 AM

How do I clear the contents of cells using a macro, with out clearing the formulas, formatting etc.??


Posted by Dogberry on February 14, 2002 4:00 PM


Use the macro recorder to record the following :-

Select the cells
Go to Edit>GoTo>Special>Constants and click OK
Press the Delete key