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!
@BUSINESSRESOURCES1304 жыл бұрын
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.
@BillHertzing4 жыл бұрын
Thank you. This will make my workflow so much easier.
@culea0alex14 жыл бұрын
THANK YOU VERY MUCH THIS HELPED ME VERY MUCH in fact this is exactly what i was looking for. Thank you.
@TheWahed78610 жыл бұрын
THIS IS A VERY VERY USEFUL TUTORIAL
@AsadShaheenAkram Жыл бұрын
My problem is solved. Very useful tutorial, Thanks
@rajgautam52824 жыл бұрын
Such a nice video. Thanks a lot.
@TeachExcel15 жыл бұрын
Glad you like them!
@pandharitalekar901511 жыл бұрын
awesome excel knowledge
@SJones-kk5lg3 ай бұрын
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.
@walker989712 жыл бұрын
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?
@choey23310 жыл бұрын
Super useful! Thank you so much.
@silvinamonteleone97378 жыл бұрын
saved me a lot of time. Thank you!
@NotCR774311 жыл бұрын
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
@marieclarity14 жыл бұрын
your videos is a big help to me. :) thank you. :)
@orzesze11 жыл бұрын
well explained, thanks !
@Rasklo933 жыл бұрын
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?
@alexich762111 жыл бұрын
I will view some of your vids. thanks
@prashantkadam892410 жыл бұрын
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
@Surfgarage7608 жыл бұрын
Nice video but how would you clear content with a macro on two worksheets at once?
@jam0to95 жыл бұрын
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?
@wikichoo10 жыл бұрын
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?
@alperak85805 жыл бұрын
thanks bro
@lkstar758 жыл бұрын
How can I retrieve the data after clear contents? Ctrol + z, doesn't work after clear.
@faezalmutairy30597 жыл бұрын
what are the equivalent shortcuts on Mac?
@NowWhat0115 жыл бұрын
How do you clear cells that contain a perticular text or number? Thanks in advance.
@India.Freedom6 жыл бұрын
How to do the same to a different Excel Workbook file?
@mokdekd6 жыл бұрын
Thank a lot
@gippsonindia38657 жыл бұрын
i am unable to clear contents of merged cell using macro... please solve my problem