Hello SBR Crew. Hope everyone is holding up well during the pause.
I have a teams' margs of victory in cells in column C
I just want VBA to show the AVERAGE of the last 5 cells in that column, column C
Does anyone know this line of code?
-------------------------------------------------------
L5AveMarg = Average of last 5 cells in column C
---------------------------------------------------------
I know I have this display right
MsgBox "Last 5 Ave = " & L5AveMarg
-------------------------------------------------------------
I know there are (Worksheet Functions) and (application functions) but I just can't get it right.
Thanks fellas.
I'm hoping only another couple of weeks before the sports betting world returns to normal.