Create range consisting only of autofilter results.

Hi,

Say I run an autofilter and 4/1000 rows become visible. I want to extract data from these rows. I have been using copy visible and paste in order to select data in the filter result rows, but lately I've noticed running this macro on different machines and running it too many times on my machine causes a problem with the cut and paste clipboard.

The last 2 columns are omitted in the paste. This is a problem in and of itself but I need help with the solution - skip the copy and paste and name the visible cells as a range.

Say: 1248 entry rows are occupied. After filter, 2 rows are visible and only these rows are selected... what can I do at this point other than copying and pasting these rows elsewhere? Naming the selection a range creates a range that includes invisible cells.

Thank you!