Why does this code sometimes not work?

[tjak]

This code is not being correctly read on a consistent basis and I don't know why. Somedays the alpha split is correct, and somedays, "Barb" gets alpha starting at "J" and sometimes starting at "M". The first split ("Jill") consistently is correct. When "Barb" is wrong, it throws off "Julie".

Can anyone tell me why the "Barb" split is not getting correctly processed
every time?
Is it the code? Is my XL corrupted? Or?

Range("d2").Select
ActiveCell.Formula = "=If(g2>2500,""BETTY"",If(a2<""G"",""JILL"",If(A2>""M"",""BARB"",""JULIE"")))"
Range("d2").Select
Selection.AutoFill Destination:=Range("D2:d" & LastRow)

Thanx.

 

[tjak]

When I added the "Left", I got run-time error "Application defined or Object defined error". I got the same error when I made all the comparisons "Left" and when I used it just on the "Barb" split. Without the "left", the formula runs, but gives "M" to Barb instead of Julie.

The frustration is that I use the identical formula format elsewhere in the code (for another alpha split) and it works fine. Also, this formula worked until 2 days ago. (A1:H1 are headers.) I do an alpha sort of the names after the split.

 

[tjak]

OK, made it work by changing the "Barb" statement to read ">N" which is correctly putting the "M's" to "Julie". How/why this decided to not work after a week I still don't know.

I also don't understand why the code is reading the statement as "=>N" for Barb when I don't have that situation elsewhere in the code.