Finding issue in If elseif else with For each Loop

[Arunachaljois]

Finding issue in If elseif else with For each Loop
I have tried this below code but i'm getting in Y column filled with W005. Colud you please help me on this ? i have uploaded a images also.
For Each cell In Range("I2:I" & LR)
If cell.Value = "W100" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[-23],""000"",RC[-20],""W004"")"
ElseIf cell.Value = "W102" Then
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[-23],""000"",RC[-20],""W005"")"
Else
Range("Y2:Y" & LR).Formula = "=CONCATENATE(RC[-23],""000"",RC[-20],RC[-16])"
End If
Next cell

 

[Fluff]

You will need to do what I said in post#49

 

[Arunachaljois]

You mean either use sheets or worksheets ? any of one ?

 

[Fluff]

No.
Look at your code & the two examples I showed, of how to ensure that the code is running on the correct sheet.

 

[Arunachaljois]

Yes i have done it to Sheets
But still is not working

 

[Fluff]

I edited post#53 as I misunderstood what you were saying.

 

[Arunachaljois]

Yes i got it
But button not working properly in RED border code
Yellow highlighted one is working fine with same button

 

[Fluff]

You have not done either of what I suggested.
Sorry but I cannot afford to spend any more time this.

 

[Arunachaljois]

Kindly request could you please just clearly explain one more last time