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?
For i = 1 To .Filters.Count If .Filters(i).On Then MsgBox .Range(1, i).Column End If Next i
Bookmarks