I need to use the AutoSum function in my macro. I cannot use the subtotal function with what I am trying to do. I cannot use the regular sum function b/c the autosum only auto sums until it reaches a formula which would be the autosum function for the last section of data. Any ideas? Thanks.