Hi,

I was wondering if anyone knows how to write a simple macro to calculate a series of averages. I need the macro to split a range of cells in a particular column into 10 equal sub-ranges (without having to specify the initial range length). For each of these sub-ranges I want to calculate the average.

I was thinking that it may be possible to specify a count of the whole column and then in another cell have a formula which divides that count into 10 to give x number of observations for each sub-range which can then be used to calculate the average. I just need it to ensure that all observations are within one of the 10 sub-ranges and that the averages do not overlap. I think that using a count or something similar with no fixed range is preferable, as this would be able to recalculate if observations are added or deleted at a later stage.