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
