Which columns are filtered

[jomili]

The code snippet below puts up separate message boxes for each filtered column in a filtered range. But instead of a separate msgbox what I really want is to capture in a string that "columns 4, 6, and 7 have filters applied". How would I get that?

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[jomili]

Shg, again, you've done it! Thanks so much!

[shg]

You're welcome.