Because I used Selection as range. Have you selected the range before running the code?
Otherwise replace the Selection property with your range like the below and check![]()
Selection.Replace
![]()
Sub ReplaceMe() Range("A1:B5").Replace Chr(220), "", xlPart, xlByRows, False End Sub
Bookmarks