Hi,

I am new to the forum. I have a spreadsheet that I need to average the following ranges A7:A11, A17:A21, A27:A31, A37:A41...A21997:A22001. How would be the best way to go about it? My assumption is with a macro? I also want to delete A2:A6, A12:16, A22:A26.... A21992:A21996. Any help would be greatly appreciated!!

I am using Excel 2003

Thanks!!
M