Fill Array with data in visible cells in column

I have filtered a column based on certain criteria. Next I want to store the data of the visible cells in column A so I can use those values (numbers) as criteria for a new filter on a different sheet.

The code I have so far works for the largest part: only I can't seem to refer to the right rownumbers of the visible rows after the first autofilter... How can I refer to the visible rownumbers?

Please Login or Register  to view this content.

Thanks ollie

I think I know How to creatie a loop, but How do I go from visible row to the next visible row?

Many thanks