Clear Cells Based On Value Using Replace Excel VBA Macro

Read the post here: excelmacroclass.blogspot.com/...
There are several ways to clear cells based on cell value with Excel VBA. The easiest, and probably also most efficient way to do it is using the Replace method of the Range object, which can replace the target value with an empty string in a given range or entire worksheet. Another possibility is looping through all cells in a range and setting a condition to clear the contents for a target value. This gets slower the bigger the range. On the other hand, this method allows not only to clear values, but also to change formatting or delete the target cell, for example. It also allows to set various conditions, instead of a single value.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)

[@nadermounir8228]

Nice video looking forward to your next video 😊

[@beverlynazareno2029]

Hi, how about if I want to clear values on colored cells? Not the whole row or column but just the highlighted ones. Or if I want to clear the cells based on the words on another cell? Thank you!

[@ExcelMacroMania]

To clear values in colored cells you need to use the other method (Part2). See the video here: ruclips.net/video/-OAfoPi-eX8/видео.htmlsi=cka8OnIL6kvOi2yz
That other method loops through target cells and checks for any condition. For example, to clear values for a cell colored yellow you do something like this:
For Each cel lIn targetRange
If cell.Interior.Color = vbYellow Then cell.Value = ""
Next cell
To clear cells based on words from other cell you can to use Offset. For example, let's say you want to clear cells which have a cell in the same row and next column with the word "DONE":
For Each cel lIn targetRange
If cell.Offset(0,1) = "DONE" Then cell.Value = ""
Next cell