MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to delete


Posted by Bill on March 30, 2001 6:45 PM

How would you write a macro to delete all the text and numbers but not the formatting in all the sheets in a workbook?


Posted by T.Rex on March 30, 2001 7:25 PM

Posted by T.Rex on March 30, 2001 7:25 PM

Posted by T.Rex on March 30, 2001 7:27 PM


Record the following with the macro recorder.

Select all sheets
Select all cells
Edit/Clear/Contents


Posted by mseyf on March 31, 2001 9:06 PM

Bill-
you could try something like:

Sub ClearAllCells()

Sheets.Select
Cells.Select
Selection.ClearContents
Range("a1").Select
ActiveSheet.Select

End Sub

HTH

Mark