There have been a couple of posts that describe the same situation.

But when those posters go back to verify that behavior, it seems to change to
what you want.

Can you test it once more?

If it still fails, you can always use:
Ctrl-g (or F5, same as Edit|Goto in the old menu system)
special
visible cells only

Then copy|paste.

Gops wrote:

I have upgraded my system from Excel 2000 to 2007.
Since I have done this when ever I do a filter and copy the data for the
filtered range the data gets copied into the unfiltered rows even when the
the data set is less than 5000 rows.

Is this a issue with excel settings?

--

Dave Peterson