Replace function not working in Macro

Hello All, needing help with the replace function. If a cell has the following contents (906, 910, 911) my macro is not replacing the numbers with text. I have tried taking the commas out, and have same issue. After the macro is completed. I try to do the replace function manually and it will not find the data. I then tried to just see if excel would find the data, and it found it. Then did the replace function again and it will now replace it after finding it.. I have duplicated this result several times. It will not replace until I run the find manually. Makes no sense to me.

I am trying to get it to change each number in the cell to different text. I.E. (906, 910, 911) would translate to (Hello, Help, Please)

Code in macro:

Columns("L:L").Select
Selection.Replace What:="906", Replacement:="Hello", LookAt:= _
xlWhole, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="910", Replacement:="Help", LookAt:=xlWhole _
, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="911", Replacement:="Please", LookAt:= _
xlWhole, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False

Thanks in advance.

"906" is text, not a number. If you leave the double quotes out, it is a number.

I took the "" out, and it still does not work on cells with multiple numbers/text... It works just fine on cells that only have one value in them.

Re: does not work on cells with multiple numbers/text
Can you give us some examples to work with?

Please Login or Register  to view this content.

Also, read the forum rules again about using code tags before you continue.

I have a sample included. The yellow highlighted cells are whats wrong. Those are codes for reasons why a ticket was closed out.
The green highlighted cells were also code numbers that I had the macro change to words for reporting purposes.
The macro works just fine for any cell that does not have more than one code number in it.

Macro code is now attached too.

Does this work on your original?
On your attachment, it is Column K your working with, not Column L.

Please Login or Register  to view this content.

Thank you, I will try the xlpart. The macro does more stuff before changing the codes, so the column was originally L, but another column gets deleted so it becomes column K

The xlPart fixed the issue. Thank you all! Much appreciated!!