| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recalculate a worksheet following an autofilter selection.
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recalculate a worksheet following an autofilter selection.
Look in the help index for SUBTOTAL to find your answer. You need not
recalculate if automatic calc. -- Don Guillett Microsoft MVP Excel SalesAid Software "Philip J Smith" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to force all of the cells in a worksheet to recalculate? | Excel Programming | |||
| Excel to recalculate a worksheet based on a time interval | Excel Worksheet Functions | |||
| Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
| How to recalculate a worksheet when a selection is made | Excel Programming | |||
| Can I only recalculate a part of a worksheet? | Excel Programming | |||
Linear Mode
