Loop through a filter

[Sgligori]

I have several values in Column 3 that I would like to loop through. Is there any way to amend this code so that it filters through all the unique values in Column 3 (and not just "Blue")?

Please Login or Register  to view this content.

[Richard Buttrey]

Yes you could easily build in functionality to filter on other colours but I don't understand the point of your macro. As it stands it filters for blue and then immediately removes the filter leaving you where you were.

[Sgligori]

My intention is to figure out a way to loop through the other colors and then unfilter.