Averaging a Range

[NewToVBA_23]

For the life of me, I cant figure out what is wrong with this piece of code. It is saying that it cant pull the the worksheet function up.

Selection.Cells((SelectionRows - 1), 9).Value = Application.WorksheetFunction.Average(Selection.Range(Cells(1, 9), Cells((SelectionRows - 1), 9)))

Please help!
Thanks in advance
Alexis

[stnkynts]

I think it has less to do with the worksheet function and more to do with your use of Selection. Remove this one and see how it works. Outside a few scenario's you really shouldnt be using selection.

Please Login or Register  to view this content.