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 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%