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!

Category:

Education

Tags:

• microsoft excel 2007
• excel guides
• tutorials
• help
• tips
• tricks
• excel macros
• vba in excel
• clearcontents
• empty cells in excel
• delete values in cells macro
• data

[kelownaken]

thanks man. your videos are clear and concise.

[ExcelisHell]

Glad you like them!

[marieclarity]

your videos is a big help to me. :) thank you. :)

[culea0alex]

THANK YOU VERY MUCH THIS HELPED ME VERY MUCH in fact this is exactly what i was looking for. Thank you.

[docjackson33]

How do you clear cells that contain a perticular text or number?

Thanks in advance.