Replacing Cell Contents in only one column

  • Thread starter Thread starter Tangier
  • Start date Start date
T

Tangier

Hello,

I am trying to replace the contents of a cell in only one column of
the spreadhseet

Right now I have coded:

Cells.Replace What:="1", Replacement:="No Data", LookAt:=xlWhole
_
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

I only want to search a specific column and replace 1 with No Data
 
Assuming your unstated replacement column is "B", use Columns("B") instead
of Cells...

Columns("B").Replace What="1", Replacement:="No Data",... etc.
 
Back
Top