VBA average 3 values loop in 1 column? : I need some help with my code. Basically, I just need to average 3 values in a column and continue that pattern until there are no more values. Can someone please help? Thank you. 
    
    
    Sub DLSaverage()
    Dim i As Long, j As Long, k As Long, l  As Long, m As Long, myRange As Range
    
    Sheets("DLS Data").Select
    i = 2
    j = 3
    k = 4
    
    Do While Cells(i, 3).Value <> ""
        'l = Cells(i, 2).Value
        'm = Cells(k, 2).Value
    
        'Cells(j, 22).Value = [Average (l : m)]
        i = i + 3
        j = j + 1
        k = k + 3
    Set myRange = Range("L" & i & ":L" & k)
    Cells(j, 22).Value = Application.Average(myRange)
    
    
    Loop
    
    End Sub