Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to properly clear data and cell contents in Excel spreadsheets using a macro. This tutorial shows you how to use the clearcontents part of excel vba to write a macro that will delete all of the contents of cells in the spreadsheets. This is the best method or way to delete everything from a cell or a range of cells in Excel.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!