ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
This code clears the cells on a sheet that have a value of "" (null) so that they are blank.
Is there a way to do the same thing for a range of cells on a sheet rather than on the entire sheet? I am hoping for a way that does not involve looping from one row to the next, which takes a long time.
Thanks
Code:
Sub Macro2()
With ActiveSheet
.UsedRange.Value = Evaluate("IF(ROW(" & .UsedRange.Address & "),CLEAN(" & .UsedRange.Address & "))")
End With
End Sub
Is there a way to do the same thing for a range of cells on a sheet rather than on the entire sheet? I am hoping for a way that does not involve looping from one row to the next, which takes a long time.
Thanks