I am trying to select the top 10 rows of a filtered list and then paste the
values into a temporary worksheet. I have tried several ways of recording a
macro that will do this but without success.
Currently the line of code that is selecting the range reads
"Range("A1:E11").Select". What should this read to always be the top ten
rows of a filtered list?

Thanks
Tony