April 21st, 2013, 11:32 AM
Macro to delete White color Text
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?
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
Thanks in Advance
Click Here to Expand Forum to Full Width