AutoFilter Macro

[jason.hampton]

All,

I am attempting to create a macro that will look at each column and ensure "select all" is selected.

Many in my office share a common workbook with thousands of rows of data and many columns. Row 5 has the "data filters" selected. Office personnel utilize these to dissect the data. My goal is to be able to run a macro and ensure someone hasn't selected or unselected filters.

Granted you can go into each column manually and ensure "select all" is checked. Any assistance would be appreciated. The code listed below was recorded and manually checking the first few columns.

Please Login or Register  to view this content.

[Solus Rankin]

maybe

Please Login or Register  to view this content.

[jason.hampton]

Another Excel guru in my network sent me this syntax as well. I have added ***Range("A6").Select*** for my own purposes. Row 5 is set to view \ freeze panes.

Please Login or Register  to view this content.