VBA code to Highlight all the Blank Cells Invisible Space

Posted by admin on 2023-01-07 17:19:11 |

Share: Facebook | Twitter | Whatsapp | Linkedin Visits: 954

VBA code to Highlight all the Blank Cells Invisible Space:

Sub blankWithSpace()
Dim rng As Range
For Each rng In ActiveSheet.UsedRange
If rng.Value = " " Then
rng.Style = "Note"
End If
Next rng
End Sub