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.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
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
Bookmarks