Print

Print


Hi everybody!

I have the following information on Sheet1 of my workbook (EXCEL97):
A1:    Title
A2:       12
A3:
A4:       12.3
A5:       12.5
A6:
A7:        12.4
A8:        13
A9:        11.9

Should it be possible to calculate the means and the variance  from C2
to C9 using vba in optimizing the code? I suppose, i don't know the
number of the rows.
Can anybody helps me ?
Best regards
Thierry





%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%