Excel Macro VBA Tip 12 – Clear Data & Cell Contents with an Excel Macro

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!

Duration : 0:4:48

Technorati Tags: clearcontents, data, delete values in cells macro, empty cells in excel, excel guides, excel macros, Help, microsoft excel 2007, tips, tricks, tutorials, vba in excel

Related posts:

1. Excel Macro VBA Tip 11 – Assign Excel Cell Contents to Variables in Excel Macros
2. Excel Macro VBA Tip – 14 Using Variables with the Cells Property in Excel Macros
3. Excel Macro VBA Tip 1 – How to Write Your Very First Macro in Microsoft Excel
4. Excel Macro VBA Tip 17 – Find Last Row and Last Column with VBA
5. Excel Macro VBA Tip 26 – Stop Cancel or Close a Macro using VBA in Excel