Filter Rows

[Guest]

Hi

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

With thanks
Boba

 

[Debra Dalgleish]

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

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