FindReplace Macro replacing parts of number value instead of considering whole number

I've copied this macro for conducting a multi find and replace across a selection. I've also attached a reduced version of the spreadsheet this applies to.

Sub MultiFindNReplaceNew()
Dim Rng As Range
Dim InputRng As Range, ReplaceRng As Range
xTitleId = "Test"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Owner Number Range ", xTitleId, InputRng.Address, Type:=8)
Set ReplaceRng = Application.InputBox("Territory Range ", xTitleId, Type:=8)
Application.ScreenUpdating = False
For Each Rng In ReplaceRng.Columns(1).Cells
    InputRng.Replace what:=Rng.Value, replacement:=Rng.Offset(0, 1).Value
Next
Application.ScreenUpdating = True
End Sub

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

When the data in 'Sheet1:Owner Number' was instead a Zip Code (essentially a 5 digit number), the macro worked perfectly to replace the Zip Code in 'Registrations:ColumnB' with the appropriate name according to the name in 'Sheet1:ColumnB'

But now that I've put the Owner Number (a variable 1-4 digit number) the macro doesn't work.
It's taking an Owner Number like '45' and replacing it with the name "StecklerKoch" instead of "Goodman" as it should.

What am I missing?

Try this update to your code.

I tried to test it but couldn't figure out what ranges I was being prompted for.

       InputRng.Replace what:=Rng.Value, replacement:=Rng.Offset(0, 1).Value, lookat:=xlWhole

Please see my note in your first post. Your other posts still did not apply code tags.

There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

[code]
' your code goes here
[/code]


Why use code tags? Code tags:

1. Are required by rules (see rule #2)
2. Preserve spacing used to show code structure (otherwise leading spaces and repeated spaces are removed)
3. Add scroll bars to navigate code with long lines or a lot of lines

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

If you solved your own problem, please provide your solution so that somebody seeing this thread in a search for the same problem will see how it was solved.