Average Numbers in Column Until Blank Cell

[chouston]

Hey guys, so I have data in column I of a spreadsheet, all numeric to two decimal points. The data starts in row 4 and will continue down a non-static number of rows, depending on how much data is exported. There is then a gap of 5 to 8 rows and numbers start again. This may repeat a few dozen times, again depending on the amount of data exported. What I am hoping to do is take those numeric sets and average them individually then output that average 2 rows below the last number in the set. I am trying to do this in VBA as part of an existing code, but I'm not sure how to go about it... Thoughts?

[rylo]

Hi

Assuming that your existing sub will make sure you are on the correct sheet, then put in a step in your existing code to run the following as a separate macro

Please Login or Register  to view this content.

HTH

rylo