There's sample code here, by Tom Ogilvy, to copy filtered rows:

http://www.contextures.com/xlautofilter03.html#Copy

Boba wrote:
I set a filter by using the AutoFilter in my worksheet.
I want read only the rows was filtered.
Simple loop will not help me since it will read also the rows was hidden by the filter.
Is there a way to read only those rows ?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html