Deleting/Replacing Values in a Range

  • Thread starter Thread starter Dan Gesshel
  • Start date Start date
D

Dan Gesshel

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
 
oops, clear method may be a tad too efficient, everything will be clear in
the range. So, Replace method is a better deal.
 
..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.
 
Back
Top