Dynamic Range average

hi
i have a macro that copys and paste a list of number for a month and adds it to new work book. this is run on a month by month basis
what im trying to do when its run for the first month it averages the list of number in a row and displays them under it.

but i want it to do it so u dont have to name the cells its looking to avaerage as when we run it for second month the new figures are entered under the last months figure and i neew to avaerage the figures month by month not every number in list

can this be done if so how

like this works for avaeraging the values when it runs once

Please Login or Register  to view this content.

but next time it runs it might add on 21 more and i just want the average of them new 21 rows it add and dispalyed after them

looking for a counter loop i suppose anyone any ideas

hi
does not seem to be writing it out

also is there a way of changing this line to be dynamic as well as i wont always be writing t to 24 as it could be sorter or longer than 24

Please Login or Register  to view this content.

actually seems to be working but not cal it right

it actuallys works had to change from long to double.

so do u think its possible to write the avaerage without naming the cell field
l

if i try it like this

Please Login or Register  to view this content.

then it add it to the first row and im trying to get to it add it after all the rows

hi
that worked
thanks so much big help