I'll have to get back to you - but do you want to be able to change the
number of minutes each time you run the macro?

Peter

" I copied the macro and it works fine though I am unable to get into
the nitty gritty of the code as I am new to VBA. On running the macro
i am able to get the the weighted average rates for every minute of
the selected range. Is there a way to get the total quanity during
every period? Also If it is not asking for too much, is it possible to
change the duration, say every 5 minutes or every 10 minutes and get
the total quantity and weighted averages during such periods?

Thanks as always.