I made a macro that does an autofiler and then subtotals the results. The
problem is that the value is set to the active cell and if I change the
filter after the macro is run, the value changes. How do I set the value of
the subtotal permanently to a cell?

Thanks