Syntax on Application.Average

[Saladsamurai]

This is a stupid question, but I am having a lot of trouble finding help on this one:

I am trying to use the "Average" worksheet function. Due to the nature of my code, it is more convenient for me to refer to ranges using the 'Cells()' method.

This works:
[VBA]RowAverage = Application.Average(Cells(i + 3, 2), Cells(i + 3, 29))[/VBA]

But this only returns the average of the 2 cells. I want the average of all cells in the RANGE Cells(i + 3, 2) To Cells(i + 3, 29)/

I tried

This
[VBA]Application.Average(Cells(i + 3, 2) : Cells(i + 3, 29))[/VBA]

This
[VBA]Application.Average("Cells(i + 3, 2)" : "Cells(i + 3, 29)")[/VBA]

Even this
[VBA]Application.Average(Cells(i + 3, 2) To Cells(i + 3, 29))[/VBA]

but all have syntax errors....Any thoughts?

[Saladsamurai]

This is stupid. I just tried using the regular old Average syntax in VBA

[VBA]Application.WorkSheetFunction.Average(A1:A20)[/VBA]

and it gave me a syntax error. Apparently in VBA, Average() will only take arguments like this:

[VBA]Application.WorkSheetFunction.Average(arg1, arg2, arg3)[/VBA]

[Bob Phillips]

[vba]

Application.Average(Range(Cells(i + 3, 2), Cells(i + 3, 29)) )
[/vba]