Try
Range("A1").Value = Range("A1").Value


"Al" wrote:

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