Replacing Contents in Cells

[Tangier]

Within my module, I would like to replace the word

Cells.Replace What:="0", Replacement:="No Spouse",
LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False

However when I do this, wherever there is a zero, I see "No Spouse" so
for the number 104, I see 1NoSpouse4

How do I specify only 0, instead of a number that may contain 0. thanx

 

[Peo Sjoblom]

Change this part


LookAt:=xlPart


to this


LookAt:=xlWhole



--


Regards,


Peo Sjoblom

 

[Tangier]

Change this part

LookAt:=xlPart

to this

LookAt:=xlWhole

--

Regards,

Peo Sjoblom











- Show quoted text -

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!