Sub loop1()
' This loop runs until there is nothing in the next column
    Do
    ActiveCell.FormulaR1C1 = "=Average(RC[-1],RC[-2])"
    ActiveCell.Offset(1, 0).Select
    Loop Until IsEmpty(ActiveCell.Offset(0, 1))
End Sub
the Code here is used in this forums VBA tips tutorials, If i copy and paste it, it works no problem and the words Do and Loop Until show up in Blue.

If i try typing the code, the word Do shows up in Blue as it does in the sample, but the Loop Until doesn't and the code fails. Is there a way to put the ending part of the syntax in via a selection drop down? I don't see it as an option and typing it's not working

Total novice at VBA