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

[@samirandas283]

Thanks for the simple and effective tutorial...

[@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!

[@BUSINESSRESOURCES130]

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.

[@BillHertzing]

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

[@culea0alex]

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

[@TheWahed786]

THIS IS A VERY VERY USEFUL TUTORIAL

[@AsadShaheenAkram]

My problem is solved. Very useful tutorial, Thanks

[@rajgautam5282]

Such a nice video. Thanks a lot.

[@TeachExcel]

Glad you like them!

[@pandharitalekar9015]

awesome excel knowledge

[@SJones-kk5lg]

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.

[@walker9897]

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?

[@choey233]

Super useful! Thank you so much.

[@silvinamonteleone9737]

saved me a lot of time. Thank you!

[@NotCR7743]

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

[@marieclarity]

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

[@orzesze]

well explained, thanks !

[@Rasklo93]

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?

[@alexich7621]

I will view some of your vids. thanks

[@prashantkadam8924]

THKS A LOT ITS REALLY HELPFUL TO ME

[@Antaviousgrier1]

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

[@Surfgarage760]

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

[@jam0to9]

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?

[@alperak8580]

thanks bro

[@lkstar75]

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

[@faezalmutairy3059]

what are the equivalent shortcuts on Mac?

[@NowWhat01]

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

[@India.Freedom]

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

[@mokdekd]

Thank a lot

[@gippsonindia3865]

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

[@perny1094]

what if cell are merged?tnx