Monday 27 November 2017

Excel - Excel Filters - AutoFilter VBA

Examples of AutoFilter VBA programming, for use with worksheet AutoFilters (only one allowed per worksheet). 

Show All Records 


Show All Records on Protected Sheet
Show All Records on Password Protected Sheet

Turn On Excel AutoFilter 

Turn Off Excel AutoFilter 

Ungroup Dates in Filter Drop Down



Count Worksheet AutoFilters 

Hide Excel AutoFilter Arrows 





Copy Filtered Rows 
Excel AutoFilter on a Protected Worksheet 


Count Visible Rows 



Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London












No comments:

Post a Comment