Erik,

Try this change as your range test will not work (I believe!):

If Range("AB23").Value = "N" And
Range("M38,M44,M50,M57,M63,M69,M74,M79,M85").Find( "Jerry", LookIn:=xlValues)
Is Nothing Then


HTH

"Erik K via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1