JugglerJAF
Active Member
- Joined
- Feb 17, 2002
- Messages
- 297
- Office Version
- 365
- Platform
- Windows
Is it possible in VBA to write some code that will return the number of columns within the current region of the active cell that have a filter applied to them?
Example: I have data from A1:E35 and filters applied to column B for one value, and column D for another value. In this instance I'd want to return a value of 2 as there are filters applied to 2 columns (B and D).
I'm not looking to count the number of rows returned by the filter, just the number of columns that have a filter applied to them.
Example: I have data from A1:E35 and filters applied to column B for one value, and column D for another value. In this instance I'd want to return a value of 2 as there are filters applied to 2 columns (B and D).
I'm not looking to count the number of rows returned by the filter, just the number of columns that have a filter applied to them.