I need some help on figuring out how to determine the AVERAGE of a range of values, and get that AVERAGE value into a specific cell.
the variable Month is an INTEGER
[vba]
Range("J2").Offset(RowOffset:=1, ColumnOffset:=1).Resize(Month).Select
[/vba]
Now what I would like to do is this:
[vba]
Cells(3, "C") = Average.Selection
[/vba]
I know that isnt the way to do it... but you can get the idea.
How can I do this in VBA?
Dave