Hi All - I have a macro coded below that looks in Column A and will essentially clear cells that look blank but aren't actually blanks. It does work, however it is very slow and I don't think I can make it client-facing in its current state. Is there a way to make it run faster and/or prettier? Thank you!
Sub ClearEmptyValues()
Application.ScreenUpdating = False
For Each cell In UsedRange.Columns("A").Cells
If Not IsEmpty(cell) And cell.Value = vbNullString Then cell.Formula = vbNullString
Next
End Sub
Sub ClearEmptyValues()
Application.ScreenUpdating = False
For Each cell In UsedRange.Columns("A").Cells
If Not IsEmpty(cell) And cell.Value = vbNullString Then cell.Formula = vbNullString
Next
End Sub