I saw this response in a different forum:

The key here is that if you select just the table (or cells in the same rows
as the table) to copy, then you will get the filtered data.

If you select the filtered cells, plus data outside the table (the row
above/below/both) then you will get the entire list (unfiltered).

You can tell what you are going to get by looking at the "running ants"
selection after pressing Ctrl+C. If you see only one area with the running
ants around the outer perimeter, you are going to get the whole table. If
you see several 'mini-selections' inside a larger bold border, then you will
get the filtered data.

===========
But your extra step of limiting the selection to the visible cells, then copying
that is a sure-fire way to make it work.

David wrote:

Hi,

Just started using 2007. Ran into something i did not expect. F5, Go To
Special, Visable Cells Only. I can do that, but if I COPY the range with
Hidden Cells included, when I paste, it pastes what was hidden to.

Will this feature stay this way? I do not think it was that way in 2003 and
was indeed a useful feature.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson