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

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.


Have a great day!

[TheYogina]

YOU ARE AWESOME! After spending hours trying to google a solution to this problem, I come to your channel and get a very clear and concise answer. Thank you!

[AsadShaheenAkram]

My problem is solved. Very useful tutorial, Thanks

[samirandas]

Thanks for the simple and effective tutorial...

[culeaalex]

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

[BillHertzing]

Thank you. This will make my workflow so much easier.

[BUSINESSRESOURCES]

Thanks this was so helpful even 11 years later to clear cells and automate the process by attaching a macro to a button. I know a lot about Excel functions on the database level but not so much VBA coding so I'm using this to add automation to my database programs. Thank you.

[marieclarity]

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

[walker]

If I have a workbook with say 30 worksheets and want to clear the contents of the same range of each sheet do I need to place the name of each worksheet into the macro, or is there a wildcard for all sheets, and if not and I need to put the names in than what is the delimiter I should use between worksheet names?

[SJones-kklg]

If the cells are part of a formula, is the formula affected by using the macro to clear the cell. I need the data to clear but the formulas to remain.

[Rasklo]

If to say, one wished to count the changes. Like if there was eleven number's in collum B, and you removed 5 because of the value given to the macro set up and then store the amount removed in a new cell. How would one go about doing so.

1: A number of Cells are removed because they were larger than the value given to the macro. In Colum B (Cell B2:B13)
2: The macro will delete all cells with a value above 300, so if a cell contains 300 or higher, then it's deleted from the form.
3: The number of cells removed been counted is put into Cell D2. So if five was removed, then Cell D2 would gain the number five, by the amount of cell's removed.

How would one go about making it so that when the change happens, then Cell D2 would be updated with the deleted number?

[NotCR]

thanks for the post, was very helpful!
how can we delete cells with different cell range?
example: deleting data from A8 Uuntil F17 and from J8 until O17
i hope you can help me with that!

thank you

[Antaviousgrier]

How do I clear a whole column after i use the auto filter without deleting the header

[jamto]

Can you clear a range of cells based on a criteria. If you have part numbers ordered and used on dates and the task is to clear all parts used on a date apart from other dates. Example- can the clear micro be used with SUMIF or SUMIFS or VLookup?

[wikichoo]

let's say you wanted the macro to delete row eleven but then, by just clicking clear again  it clears row 10 and then row 9 and so on. How would you do that?

[Surfgarage]

Nice video but how would you clear content with a macro on two worksheets at once?

[faezalmutairy]

what are the equivalent shortcuts on Mac?

[India.Freedom]

How to do the same to a different Excel Workbook file?

[NowWhat]

How do you clear cells that contain a perticular text or number?
Thanks in advance.

[lkstar]

How can I retrieve the data after clear contents?
Ctrol + z, doesn't work after clear.

[gippsonindia]

i am unable to clear contents of merged cell using macro...
please solve my problem