VBA Excel...Loop through a filter

Could you give us a bit more detail? For example, why do you want to select the cells? If it's to copy them to another location, then you should be able to just select and copy the whole data block and only the visible cells will be copied.

Ok..For each iteration of the loop I would like to

select first/next item from filter.
Select cells
Run a macro

The values in the column which I will be filtering on change it month.

Oh I see what you mean. There is no programmatic access to the contents of the filter drop down so you would have to loop through all the data and create a unique list of items and then apply each of those to the filter. Can you elaborate as to what this macro is that you want to run on each set of cell - there may be an easier way to achieve your end goal.

In detail the whole loop would need to do:

select first/next item from filter.
Select cells
export the selected cells to a new Excel file

Can you post a sample workbook showing the data layout and tell us which field(s) you want to filter on and what you want the new workbooks to be called?

Might be easier if I ask you specif questions.

at the moment filter I have to specify the value. For example:

Selection.AutoFilter Field:=1, Criteria1:="Shop1"

Is there anything which would allow me to filter on the first item in the filter dropdown list.

For example:

Selection.AutoFilter Field:=1, Criteria1:=1

What do you need to know about my layout

rowcount needs to be defined btw, like with

rowcount = Range("A65536").End(xlUp).Row

which should come AFTER the two filters are done, but before the copy.

Where is the data (sheet and columns), and which column are you filtering on?

I am filtering on sheet1 and column A

thanks