Create VBA Macro Button to Clear Specific Cells | Multiple Ranges | Keep Formatting | All Sheets

Sir Chester, good day. I wanna ask you why it can't be saved and everytime I open a workbook, s gone. Thank you.

Very Helpful!! Especially the enable macros function.

You are a lifesaver thank you

Very clear, and allowed me to clear multiple and disparate entry cells in a sheet by using a named range (perhaps add named range as an example). However, I could not get it to work when some of the entry cells were merged cells. Looking for this solution as my sheet is an entry form where different width fields are used on each row (so changing column width to avoid merging is not a great option)

Thanks for this! Now I''m trying to clear a range of cells. So, I've done this and I'm actually clearing a column of data. The data leaves the cells in the row, but I've also got a duplicate conditional format in that column. When I clear the data, the cells turn pink, almost as if the "no data" cells are duplicated. Then, when I manually highlight those cells and press the "delete" key, the cells return to white as normal. When I check the cells then, they still have the duplicate rule on them. I can't figure out why that row is turning pink and furthermore how to correct this. Here is the code I've set to hopefully return that column to no fill. Range("A4:A39").Interior.ColorIndex = xlNone Can you help? FYI, My sheet would most resemble the Non-consecutive cells portion of this tutorial.

You learn something new every day. This was very useful!! It’s gonna make my life easier at work.

Thanks, your vid is really simple, helpful, and easy to understand. Subscribed

Kindly release a video for clearing data of merged cell

Is there a way to clear merged cells as well?

Thanks sir

Thank you!

Hi i have a doubt

Can we have a button which can Clear all the contents of the multiple sheets present in the same workbook

If yes

Can help me with the VBA code

Very useful! Many examples which can be used in different real life scenarios. Thanks

When I try this, I get a Compile Error - Wrong number of arguments or invalid property assignment 😌

This was great thanks so much.. Is there a way to get the code to recognize merged cells? Thanks

Very good

When you looped through all the worksheets and cleared each one, why didn't the button disappear too?

Thanks Chester. By the way, did you know that you don't have to type the parentheses after typing the title of the subroutine because the VBA editor will take care of that.

Thank you Chester. That's a very useful macro-set.