Recalculate a worksheet following an autofilter selection.
in [Programming]
|
Prev: Passing dates to Sql Server 2005 stored procedure
Next: Shading cells that contain formulas and conditional formatting at the same time.
From: Philip J Smith on 7 Jun 2010 05:50 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
From: Don Guillett on 7 Jun 2010 08:36
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 dguillett(a)gmail.com "Philip J Smith" <PhilipJSmith(a)discussions.microsoft.com> wrote in message news:0458E568-DEF5-412C-AAAB-070A61B3C413(a)microsoft.com... > 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 |