OK, so we are no longer talking about the ElseIf or the Find method but
the If statement.

If you use range(discontinuous range).value, you only get the value of
the first range. If the first range contains only 1 cell you get back
that value. If it has multiple cells, you get back an array.

Use the code below and the Locals Window of the VBE to see the
difference:
Sub testValue()
Dim x, y
x = Range("a1:a2,a4").Value
y = Range("a1,a2,a4").Value
Stop
End Sub
Before running the code enter some values into a1:a4, say, the numbers
1, 2, 3, and 4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <59434696623d0@uwe, u13156@uwe says...
Well if you look at the If statement prior to the "find" it should recognize
that M50 has "Jerry" in that cell and not run the "find" for alternate. For
some reason it was still running a search for alternate. My objective was to
get it to skip the search since M50 was populated with Jerry.

Tushar Mehta wrote:
From what I can tell your code is doing exactly what it is programmed
to do!

Assuming that AB25 contains something other than N and AB23 contains N,
M50 will contain Jerry.

The Find method is searching for Alternate not for Jerry as in
Selection.Find(What:="Alternate",...

So, there is no reason to expect it will find Jerry.

The Replace method is replacing Alternate with Jerry.
ActiveCell.Replace What:="Alternate", Replacement:="Jerry",...

The code is doing exactly what it is programmed to do. It might not be
your intent but that is another story.

I have set a condition :

[quoted text clipped - 30 lines]

Help! I have no idea where my problem lies.