As a sidenote, is there a reason to do this in VBA in this specific way? I am no expert on pivot tables, but this type of problem (sum the values for several account numbers over a range of dates) seems like the perfect problem for a pivot table to solve. Pivot tables also tend to function very quickly.