see ans in your other post

--
Don Guillett
SalesAid Software

"Joost" wrote in message
...
Hello,

I want to create a function in VBA for example the averge of a range (10
rows). In the following row the same formula but now with a different
range
(still 10 rows) but starting from next row.


How can this be done in VBA

Thanks in advanced