Setting Funtion Value to Cell

[Al]

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

[JMB]

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