I tried, but couldn't get it to work... I've got a spreadsheet where I'm using the Subtotal function on a range that is filtered. That all works fine. However, I have some VBA code that will increase and decrease the range size for that subtotal. Is there a way to write the formula so that the subtotal function works as I filter the data, but it also re-sizes itself as the overall range grows and shrinks? Here are the options that I tried...

=SUBTOTAL(9,AN4:COUNTA(Targeted Business List!$AN$4:$AN$1000),1)

=SUBTOTAL(9,OFFSET(Targeted Business List!$AN$4,0,0,COUNTA(Targeted Business List!$AN$4:$AN$15000),1))
* This version came from code that I'm using for a named range that dynamically changes the size of the named range.

Neither of those worked, but I figure there has to be a way. Any help would be appreciated.

Thanks!!!