Recalculate a worksheet following an autofilter selection.

P

Philip J Smith

Hi

I'm trying to work out how to recalculate a worksheet once a filter
selection has been made.

I think I need to use a worksheet selection change event but I do not know
how to detect the filter change.

Recalculating the sheet is simply: ActiveSheet.Calculate

The filters are in A3:D3.

The values to recalculate are SUBTOTALs in E2:H2

Kind Regards

Phil
 
D

Don Guillett

Look in the help index for SUBTOTAL to find your answer. You need not
recalculate if automatic calc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to force all of the cells in a worksheet to recalculate? 6
doent recalculate on save 4
How can I detect change to Autofilter selection 1
Autofilter turn off with macro 3
Autofilter by combobox selection 1
Invoke macro on Autofilter Criteria Selection 2
Autofilter on Multiple Worksheets 5
Dynamic worksheet selection using messagebox 3

Top