IF/ELSEIF not working as expected

Hey,

I've got a loop running which holds an IF/ELSEIF. They work on the pretty much the same conditions but only the IF works and never the ELSEIF.

For cellCount = 1 To lastcell 'example : 1 to 150
If quoteSheet.Cells(cellCount, 3).Value = "SYSTEM" Then
'Do this
ElseIf quoteSheet.Cells(cellCount, 4).Value = "MISCELLANEOUS" Then
'Do that
End If
Next cellCount

Anything obvious I'm missing here ?

Thanks,
amphi

1. In your Elseif you have column 4, is that right? -in If it is 3.

2. Maybe just a typo in Elseif "MISCELLANEOUS" or in your column 4 there is no such word.

3. Did you give your variable "lastcell" a value in "For cellCount = 1 To lastcell"?