VBA - Excel: Loop through filter values -

basically got filter on column , want perform per filter result set of actions on resulting data. have macro actions need do, wondering how can loop through values in filtered column. i'll explain simple example.

i have following example data:

now filter column filter, first select filter value

now filtered a, perform actions need on remaining data. how can make macro loop through filter results. first select filter, perform actions, remove filter , select b filter, perform actions, etc.

note: amount of filter data variable.

tl;dr: how make or while loop can run 1 , checks whether there next filter result or not , selects it.