I want to replace all blank cells in the group from J4 to the last row with a
-. Here is the macro that I wrote. However, when it runs, it replaces all
blank cells in the sheet, not just the ones that I want. Thank you for your
help.


With wks_E.Range("J4:J" & ExistingFinalRow)
Cells.Replace What:="", Replacement:="-", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End With