Instead of doing a macro and inserting rows then tallying the sums... try
using the subtotal command on the data menu.. It will do everything you're
describing (and add cool grouping icons to the left) without any coding that
has to be maintained..

"Tom Cote" wrote:

I have a macro that starts at the top of a column(sorted by date) and moves
down row by row and inserts two blank lines when the date changes. I know
want to go down the rows again and sum the hours for each block by date and
then copy to the cells next to it.
--
Thanks,
TC