Hi Guys,
The below coding deletes the whole cell when it contains white color text.
Whereas, How to Delete the White color Text, when it is partially in the cell?Code:Sub Try_This_A() Dim c As Range, wsh As Worksheet For Each wsh In ActiveWorkbook.Worksheets For Each c In wsh.Range("A1").CurrentRegion If c.Font.Color = RGB(255, 255, 255) Then c.ClearContents Next c Next wsh End Sub
Thanks in Advance