Replacing Contents in Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tangier - 29 Aug 2008 21:50 GMT

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

Reply to this Message

Peo Sjoblom - 29 Aug 2008 22:02 GMT

Change this part

LookAt:=xlPart

to this

LookAt:=xlWhole

Signature

Regards,

Peo Sjoblom

> Within my module, I would like to replace the word
>
[quoted text clipped - 8 lines]
>
> How do I specify only 0, instead of a number that may contain 0. thanx

Reply to this Message

Tangier - 29 Aug 2008 22:16 GMT

> Change this part
>
[quoted text clipped - 24 lines]
>
> - Show quoted text -

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

Reply to this Message