Function newavg()
Dim rng As Range
Set rng = Union(Application.ThisCell.Offset(0, -2), Application.ThisCell.Offset(0, -4), Application.ThisCell.Offset(0, -6), Application.ThisCell.Offset(0, -8))
newavg = Application.WorksheetFunction.Average(rng)
End Function
Function newavg()
Dim rng As Range
Set rng = Union(Application.ThisCell.Offset(0, -2), Application.ThisCell.Offset(0, -4), Application.ThisCell.Offset(0, -6), Application.ThisCell.Offset(0, -8))
newavg = Application.WorksheetFunction.Average(rng)
End Function