I have a CPK sheet that i am having a CMM dump data into automaticlly. My
problem is I need the formula for the average to grow along with the additon
of cells that I insert with a macro. Right now the formula is just
=AVERAGE(E12:E12)because there is only one line, but when I insert a cell I
want it to change to =AVERAGE(E12:E13)....etc..etc. How would I accomplish
this?

Thanks
Josh McCarley