BillLambeer
Board Regular
- Joined
- Jan 14, 2003
- Messages
- 51
I have a sheet which I Autofilter with a macro. However I only want to copy the first 10 rows that the Autofilter returns.
For example, I ask the Autofilter to return the Top 10 values. If all the values are the same it will return all the rows. I want to be able to copy only the first 10 of those rows.
Basically, I want to be able to copy a specific number of visible rows. Should I do this with a loop or is there a way to tell the Autofilter to return the top 10 values up to a maximum of 10 rows?
For example, I ask the Autofilter to return the Top 10 values. If all the values are the same it will return all the rows. I want to be able to copy only the first 10 of those rows.
Basically, I want to be able to copy a specific number of visible rows. Should I do this with a loop or is there a way to tell the Autofilter to return the top 10 values up to a maximum of 10 rows?