Hello.

I am trying to delete (or replace with nothing) values in a range. For
example, the word "Blank" in the following range I am using:

sInput.Range("Y22:Y200").Replace What:="Blank", Replacement:="",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

This works, but is there a better way of writing this... or perhaps
something more efficient? I don't have to necessarily use replace, as
deleting these values would suffice. Any help would be appreciated.

Thanks.

Dan

..clearcontents and .clear wipe out the whole range.

I can't imagine anything more efficient than what you first came up
with, for the selective processing you indicate.